Skip to content

Instantly share code, notes, and snippets.

@delameko

delameko/postgres.sh

Last active September 21, 2018 10:21
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 delameko/9723258112b0b333a42576fdfd580f27 to your computer and use it in GitHub Desktop.
Save delameko/9723258112b0b333a42576fdfd580f27 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres cheatsheet
Raw
postgres.sh
# List users (with permissions)
\du
# List databases
\l
# List schemas, with privileges
\dn+
# List table privileges
\dp <table name>
# List functions
\df
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment