Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
Frequently used commands in Postgres database with psql command line tool
Connect to local server using psql command line tool with postgres user.
sudo -u postgres psql postgres
To set/change password of postgres user
\password
To check/list all databases
\list or \l
To see/list all tables in current...
Creating PG Backup On Heroku
As we all know that creating a backup of your project is very crucial for any application , not just to recover your application in case of any unseen conditions but also for testing , creating a new server , migration etc.
Until recently her...
Export Postgres table to CSV
Postgres
PostgreSQL is a powerful, open source
object-relational database system. It supports storage of
binary large objects, including
pictures, sounds, or video. It compatible with may of programming interfaces like
PHP, C/C...
How to restore backup from sql script through Postgre console
Restoring backup from sql script through Postgre console is just a 2 step process.They are as follows:
Step 1: psql -h hostname -U username database_name
Step 2: \i filename.sql
