| 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: | Whole Thread | Raw Message | 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. +
| 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 |
| 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 |