Basic PostgreSQL commands

gistfile1.txt

Create superuser
$ createuser -P -s -e username
psswd: 

$ psql -U username

List databases
postgres=# \l

\q: Quit/Exit
\du: List users

Remove database
postgres=# REVOKE CONNECT ON DATABASE database_name FROM public;

postgres=# SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name';

postgres=# drop database database_name;

Use db
postgres=# \c database_name

list tables in connected database
postgres=# \dt

list columns on table
postgres=# \d <tablename>

backup database
$ pg_dump <databasename> > <outfile>