Posted By

benpjohnson on 05/19/08

Tagged

sql
query
csv

Versions (?)

Last Edited at 05/19/08 06:20am

Statistics

Viewed 836 times

Favorited by 0 user(s)

Related snippets

Postgres output CSV

/ Published in: Other

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

\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;