Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Roger Leigh <rleigh@codelibre.net>
Cc: Andrew Dunstan <andrew@dunslane.net>, Peter Eisentraut <peter_e@gmx.net>, "Brad T. Sliger" <brad@sliger.org>, pgsql-hackers@postgresql.org, Robert Haas <robertmhaas@gmail.com>, Selena Deckelmann <selenamarie@gmail.com>, Alvaro Herrera <alvherre@commandprompt.com>, Roger Leigh <rleigh@debian.org>
Date: 2009-09-30T22:50:46Z
Lists: pgsql-hackers 
Roger Leigh <rleigh@codelibre.net> writes:
>> 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.

> The attached patch implements this feature.  It adds a
> --no-pretty-formatting/-G option to psql (naming isn't my fort,
> so feel free to change it!).  This is also documented in the
> SGML docs, and help text.  Lastly, this option is used when invoking
> psql by pg_regress, which results in a working testsuite in a UTF-8
> locale.

It would be a good idea to tie this to a psql magic variable (like
ON_ERROR_STOP) so that it could conveniently be set in ~/.psqlrc.
I'm not actually sure that we need a dedicated command line switch
for it, since you could use "-v varname" instead.

			regards, tom lane