Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@baybatu

baybatu/export-psql-to-csv-file.md

Created February 16, 2022 05:51
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 baybatu/2c880788c185a6707336519a1ba4ba1e to your computer and use it in GitHub Desktop.
Save baybatu/2c880788c185a6707336519a1ba4ba1e to your computer and use it in GitHub Desktop.
Download ZIP
export psql query result to csv file
Raw
export-psql-to-csv-file.md 
\copy (select column1, column2 from mytable) To '/tmp/dump.csv' With CSV DELIMITER ',' HEADER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment