Last active
September 21, 2018 10:21
-
-
Save delameko/9723258112b0b333a42576fdfd580f27 to your computer and use it in GitHub Desktop.
Postgres cheatsheet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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