Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roger Leigh <rleigh(at)codelibre(dot)net>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>, "Brad T(dot) Sliger" <brad(at)sliger(dot)org>, pgsql-hackers(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Selena Deckelmann <selenamarie(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Roger Leigh <rleigh(at)debian(dot)org>
Subject: Re: Unicode UTF-8 table formatting for psql text output
Date: 2009-09-30 22:50:46
Message-ID: 8595.1254351046@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Roger Leigh <rleigh(at)codelibre(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Andrew GierthDate: 2009-09-30 22:55:33
Subject: Re: latest hstore patch
Previous:From: Kevin GrittnerDate: 2009-09-30 22:13:04
Subject: Re: FSM search modes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group