How to create CSV file from SQL?

Question

I am wondering how to create or export CSV file from SQL? Is tehre any function for that similar as pgsql2shp????? I would appreciate your ideas, tip or solutions.

Answer 1

COPY tablename TO STDOUT CSV

http://www.postgresql.org/docs/8.4/static/sql-copy.html

Answer 2

You can give this a try. But i believe there may be some syntax changes depending on the version.

COPY (SELECT foo,bar FROM whatever) TO ‘/tmp/dump.csv’ WITH CSV HEADER

Answer 3

If you use pgAdmin, you can export any query you run to a CSV file.