Re: Export CSV from psql

I use the standard pipe signs as delimiters, comma's are a pretty silly
delimiter if you ask me.  Try putting this at the top of your psql query

--   \a             toggle between unaligned and aligned output mode
--   \t             show only rows (currently off)
--   \o [FILE]      send all query results to file or |pipe
\a
\t
\o /tmp/outputfile.txt
select ......
\o

Don't know if this helps you, or if you really need CSV.  Someone probably
has written a CSV export I 'spose.

Best of luck.

Craig


On Thu, 20 Nov 2003, Alex wrote:

> Hi,
> is there a way to display the table in CSV format or write a query in
> csv to a file ?
>
> Alex
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>