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
> 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
In response to
pgsql-hackers by date
|Next:||From: Marko Kreen||Date: 2009-10-31 20:45:29|
|Subject: Re: Weird PL/Python elog output|
|Previous:||From: Tom Lane||Date: 2009-10-31 18:59:58|
|Subject: Re: Patch set under development to add usage reporting. |