Re: Unicode UTF-8 table formatting for psql text output

[Andrew Dunstan <andrew(at)dunslane(dot)net>]

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