Skip to content

Instantly share code, notes, and snippets.

@buithehoa

buithehoa/save-postgresql-output-to-csv.sql

Created September 22, 2015 09:36
Show Gist options
  • Save buithehoa/edf36e6137f35de4ab34 to your computer and use it in GitHub Desktop.
Save buithehoa/edf36e6137f35de4ab34 to your computer and use it in GitHub Desktop.
Download ZIP
Save PostgreSQL output to CSV
Raw
save-postgresql-output-to-csv.sql
COPY (SELECT * FROM foo) T0 '/tmp/foo.csv' WITH CSV;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment