How to export CSV data from PostgreSQL

Journal entry November 7, 2011

Just because I can never remember how to do this:

psql my_database -c "COPY (SELECT stuff FROM my_table) TO STDOUT CSV" > my_file.csv

Works in at least PostgreSQL 8.4.

Did you know?: Jakob is an independent web application developer who builds awesome stuff for the web. You can hire him to build awesome stuff for you.

Comments and Trackbacks

Commenting on this entry has been closed.