I keep finding myself looking for this information so I have started compiled a cheatsheet of psql commands. Enjoy.


$ psql postgres

\l #show all databases
\c databaseName #switch databases
\dt #show all tables in current database
\d+ tableName #show schema of tableName in current database
\du #show all users
create database databaseName; #create database
drop database databaseName; #drop database
\q #quit

ALTER USER myuser WITH SUPERUSER; #make user a superuser
ALTER USER myuser WITH NOSUPERUSER; #remove superuser from user