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

Alvaro Herrera <alvherre@commandprompt.com>

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Peter Eisentraut <peter_e@gmx.net>, Roger Leigh <rleigh@codelibre.net>, Tom Lane <tgl@sss.pgh.pa.us>, "Brad T. Sliger" <brad@sliger.org>, pgsql-hackers@postgresql.org, Robert Haas <robertmhaas@gmail.com>, Selena Deckelmann <selenamarie@gmail.com>, Roger Leigh <rleigh@debian.org>
Date: 2009-09-30T18:02:43Z
Lists: pgsql-hackers
Andrew Dunstan escribió:
> 
> 
> Peter Eisentraut wrote:
> >On Wed, 2009-09-30 at 11:03 -0400, Andrew Dunstan wrote:
> >>Thinking about this some more, ISTM a much better way of
> >>approaching it would be to provide a flag for psql to turn off
> >>the fancy formatting, and have pg_regress use that flag.
> >
> >Well, it might not be a bad idea, but adding a feature just to satisfy
> >the test suite instead of fixing the test suite doesn't feel satisfying.
> >Is there another use case?
> 
> Sure, as Tom noted pg_regress probably won't be the only user. There
> are lots of legacy scripts out there that parse psql output, and it
> should be of use to them.

All scripts I've seen parsing psql output use unaligned, undecorated
mode.  I have yet to see one messing with the |'s.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support