Skip to content

Instantly share code, notes, and snippets.

@joerx

joerx/psql.md

Last active July 22, 2019 11:02
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save joerx/15b1ed73315f2c42353dd077771bbb17 to your computer and use it in GitHub Desktop.
Save joerx/15b1ed73315f2c42353dd077771bbb17 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Cheat Sheet
Raw
psql.md

List databases

\list
\l

Connect

\connect
\c

List Tables

\dt

Export Stuff to CSV

Copy (Select * From foo) To '/tmp/test.csv' With CSV DELIMITER ',';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment