Last active
March 28, 2017 23:37
-
-
Save langsharpe/c71012ed1e48221af612b94d299c27d1 to your computer and use it in GitHub Desktop.
psql shortcuts
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
| # Dump into a "custom" compressed format | |
| pg_dump -Fc db_name > db_name.dump |
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
| \x on # Turns on "Expanded display" of query results | |
| \l # List Databases | |
| \dt # List tables | |
| \d+ public.tablename # Show table columns |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment