Re: One-shot expanded output in psql using \G

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: "Stephen Frost" <sfrost(at)snowman(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>,"Christoph Berg" <christoph(dot)berg(at)credativ(dot)de>,"PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: One-shot expanded output in psql using \G
Date: 2017-01-31 12:21:49
Message-ID: 436a5f94-797b-487b-a641-8fe997d79d75@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Stephen Frost wrote:

> That's not how '\dx' works, as I pointed out, so I don't see having the
> second character being 'x' to imply "\x mode" makes sense.

\gx means "like \g but output with expanded display"
It turns out that it's semantically close to "\g with \x" so
I refered to it like that as a shortcut upthread, my fault.
It was never meant to establish a precedent that combining
two letters would mean "do the first one-letter command and the
second as a sub-command" which indeed woud be inconsistent with
the existing \ef, \sf, \sv, \d[*] and so on.

> I can't recall ever using the other formatting toggles (aligned, HTML,
> and tuples only) before in interactive sessions, except (rarely) with
> \o.

\a is handy to read sizeable chunks of text in fields that
contain newlines, and personally I need it on a regular basis
in interactive sessions. It depends on the kind of data you have to work
with.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rahila Syed 2017-01-31 12:23:50 Re: Parallel Index Scans
Previous Message Daniel Verite 2017-01-31 11:57:45 Re: Improvements in psql hooks for variables