psql Cheatsheet - gecko-8/devwiki GitHub Wiki
psql --help
help
General Help
\h
SQL Command Help
\?
psql Command Help
\x
\df
psql -h <localhost or IP> -p <port> -U <username> -d <database name>
NOTE: Most parameters are optional
NOTE: Case is important!
\l
\c <database name>
\d
\dt
\d <table name>
\dT
\d <type>
\copy (<query>) TO '<path to file>' DELIMITER ',' CSV HEADER;
e.g. \copy (SELECT * FROM person) TO '/home/jasonl/Desktop/sql/results.csv' DELIMITER ',' CSV HEADER;