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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
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 17:06:49
Message-ID: 200804031706.m33H6nK03082@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> 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.

But break for others who want all output \x.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-04-03 17:07:44 Re: Small TRUNCATE glitch
Previous Message Bruce Momjian 2008-04-03 17:06:26 Re: psql \G command -- send query and output using extended format

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2008-04-03 17:19:21 Re: psql command aliases support
Previous Message Bruce Momjian 2008-04-03 17:06:26 Re: psql \G command -- send query and output using extended format