Frequently Used PostgreSQL commands

Several frequently used PostgreSQL command:

1. Change user to postgres with

$ sudo su - postgres

2. Start PostgreSQL client with

$ psql -d DB_NAME -U USER_NAME

3. quit psql

postgres=# \q

4. show database users

postgres=# \du

5. show data_directory

postgres=# SHOW data_directory ;

6. list all databases

postgres=# \l

7. change user password

postgres=# ALTER USER username WITH password '123123' ;

8. change user attributes (like SUPERUSER)

postgres=# ALTER USER username WITH SUPERUSER
postgres=# ALTER USER username WITH CREATEDB ;

9. switch between databases

       postgres=# \connect DBNAME 

10. describe table:

       postgres=# \d+ TABLENAME