hansrajdas/postgres.md

## postgres.md

      
    Raw
  

              postgres.md
            
          
    Connect to postgres DB

Install psql and use below command from shell
psql postgres://username:password@hostname:5432/db_name

# With some params
psql postgres://username:password@hostname:5432/db_name?application_name=root_connection
Postgres commands

List all databases

\l

Change to given DB_NAME

\c <DB_NAME>

List all tables within current DB

\d

Describe table - view table schema

\d <TABLE_NAME>

\d+ <TABLE_NAME>

select column_name, data_type from information_schema.columns where table_name = '<table_name>'

Toggle extended display

\x