Skip to content

Instantly share code, notes, and snippets.

@gembin

gembin/postgres-export-data-to-csv.md

Created December 13, 2019 05:15
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 gembin/dfcfe536af8bdd2947330582b0aa38f4 to your computer and use it in GitHub Desktop.
Save gembin/dfcfe536af8bdd2947330582b0aa38f4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres-export-data-to-csv.md 
export PGPASSWORD=xxxx
psql -h xxx_host -U xxx_user -p xxx_port -d xxx_db -q -A -F ',' -f xxx_query.sql > xxx_output.csv
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment