cheat sheets.

in psql:


\f ','
\a
\t
\o /tmp/outfile.csv
SELECT * FROM your_table;
\o
\q


also you could set \f to '\t'