Roger Leigh wrote:
On Sat, Oct 31, 2009 at 12:25:22PM -0400, Andrew Dunstan wrote:
Roger Leigh wrote:
Wouldn't it be much simpler all around to add a "csv" output format
in addition to the above for this purpose? Spreadsheets can read
it in with no trouble at all.
We've had CSV output since version 8.0.
Really? The only references I see are in tab-complete.c relating to
COPY.
You can set the field separator to ',' but you can't do a
\pset format csv
and get CSV with correct quoting, escaping etc AFAICS. It'll
still break on line wrapping if wrapping is enabled, and with
newlines in the data.
If that would be a useful addition, I can add it.
It's done by the backend, not by psql, but it has psql support - see \copy
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers