Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

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...

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
Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: