Skip to content

Instantly share code, notes, and snippets.

@thb

thb/PSQL CheatSheet

Last active April 6, 2018 08:54
Show Gist options
  • Save thb/1a9063af63f3e9b6ccb2737dae3dbf06 to your computer and use it in GitHub Desktop.
Save thb/1a9063af63f3e9b6ccb2737dae3dbf06 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PSQL CheatSheet
\list or \l - to display databases
\connect or \c database_name - to connect to a database
\dn - list of schemas
SHOW search_path;
SET search_path TO xxxxxx;
\dt - to list tables
\d+ tablename - do describe a table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment