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

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
Sign In

Sign up using

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: