Last active
October 9, 2023 00:05
-
-
Save peacefixation/d6f3ae9a4adb43a7ce2a8fc63391209c to your computer and use it in GitHub Desktop.
Postgres Cheat Sheet
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
| -- copy query to CSV | |
| \copy (select * from some_table) TO '/tmp/query-xxx.csv' CSV HEADER | |
| -- dump table to SQL inserts | |
| pg_dump -h <host> -U <user> --schema=<schema> --table=<schema.table> --data-only --column-inserts <database> > output.sql |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment