Alexfilus/pg_to_csv.txt

Created December 9, 2019 11:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Alexfilus/b8165142f13c8e31e43e1815ecbbabd5.js"></script>
Save Alexfilus/b8165142f13c8e31e43e1815ecbbabd5 to your computer and use it in GitHub Desktop.

Download ZIP

PG to CSV

Raw

pg_to_csv.txt

psql -U postgres -d name -h host.com -p 5432 -c "COPY (SELECT id, name FROM user LIMIT 10) TO STDOUT With CSV HEADER DELIMITER ',';" > foo_data.csv

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment