Skip to content

Instantly share code, notes, and snippets.

@bq1990
Forked from Kartones/postgres-cheatsheet.md
Last active August 29, 2015 14:11
Show Gist options
  • Save bq1990/91e37fcae9ec450f4b5b to your computer and use it in GitHub Desktop.
Save bq1990/91e37fcae9ec450f4b5b to your computer and use it in GitHub Desktop.

Magic words:

psql -U postgres

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

  • \q: Quit/Exit
  • \c __database__: Connect to a database
  • \d __table__: Show table definition including triggers
  • \dt *.*: List tables from all schemas (if *.* is omitted will only show SEARCH_PATH ones)
  • \l: List databases
  • \dn: List schemas
  • \df: List functions
  • \dv: List views
  • \df+ __function : Show function SQL code. \x before pretty-formats it
  • SELECT * FROM pg_proc WHERE proname='__procedurename__': List procedure/function
  • SELECT * FROM pg_views WHERE viewname='__viewname__';: List view (including the definition)
  • SELECT pg_size_pretty(pg_total_relation_size('__table_name__'));: Show DB table space in use
  • SELECT pg_size_pretty(pg_database_size('__database_name__'));: Show DB space in use

Casting:

  • CAST (column AS type) or column::type
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment