Re: psql \G command -- send query and output using extended format

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Dawid Kuroczko <qnex42(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql \G command -- send query and output using extended format
Date: 2008-04-03 16:49:28
Message-ID: 20080403164927.GB22851@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Thu, Apr 03, 2008 at 12:07:54PM -0400, Bruce Momjian wrote:
> > Alternating between formats using "\x" is, at least for me, a bit
> > cumbersome: usually _after_ I wrote a query I realize "it would
> > look more readable in expanded format", which is a bit too late.
> > So I run the query, ctrl+c, \x, rerun the query... and forget to
> > turn expanded mode off afterwards.
>
> It seems more helpful if there were \x option to use extended format
> only when the output is too wide. TODO already has:

I was thinking that maybe \x should have a one-shot mode, i.e.

\x <query>

does it only for this one statement. It would solve the OPs problem.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Atkins 2008-04-03 16:50:28 Re: modules
Previous Message D'Arcy J.M. Cain 2008-04-03 16:46:30 Re: modules

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-03 17:00:50 Re: [PATCHES] Re: BUG #4070: Join more then ~15 tables let postgreSQL produces wrong data
Previous Message Alvaro Herrera 2008-04-03 16:44:04 Re: psql \G command -- send query and output using extended format