Skip to content

Instantly share code, notes, and snippets.

@mrgcohen

mrgcohen/psql_dump_tables.sh

Created June 2, 2015 14:41
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 mrgcohen/b35d5bd305935c363406 to your computer and use it in GitHub Desktop.
Save mrgcohen/b35d5bd305935c363406 to your computer and use it in GitHub Desktop.
Download ZIP
dump tables from psql as csv
Raw
psql_dump_tables.sh
psql -c "COPY tablename TO stdout DELIMITER ',' CSV HEADER" datasbasename -U username -h hostname -W > filename.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment