\f ','
\a
\t
\o /tmp/moocow.csv
SELECT foo,bar FROM whatever;
\o
\q

If a field has newlines, this will break. You can do something like this instead.....

 SELECT foo, bar, '"' || REPLACE(REPLACE(field_with_newilne, '\n', '\\n'), '"', '""') || '"' FROM whatever;

http://pookey.co.uk/blog/archives/49-Outputting-from-Postgres-to-CSV.html

Postgres output CSV

sql, query, csv

Other