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 |