Re: Unicode UTF-8 table formatting for psql text output - Mailing list pgsql-hackers

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