02 May 2014
PSQL Cheatsheet
start
psql | Start an interactive terminal |
database
\list | List databases |
\connect <db> | Switch connection |
SELECT current_database(); | Show database connection |
tables
\d | List tables |
\d <table> | List table columns |
SELECT current_database(); | Show database connection |
help
\? | List backslash commands |
\help | List SQL commands |
quit
\q | Quit |