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

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: psql \G command -- send query and output using extended format
Date: 2008-04-03 07:23:06
Message-ID: 758d5e7f0804030023j659d72e6nd66a9d6b93b30886@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hello!

Attached is a simple patch which adds a "\G" backslash command, that is
similar "\g" command. The difference is that "\G" prints results using
extended output format. After the query the format is reset to the original
value.

In other words command like:
SELECT * FROM pg_stat_activity\G
is similar to doing:
\x on
SELECT * FROM pg_stat_activity\g
\x on or off -- depending on the original state.

Rationale: switching format using "\x" for duration of single query I find
a bit uncomfortable. This is similar to "\g file" which is one-shot version
of "\o file" command.

Regards,
Dawid

Attachment Content-Type Size
psql-G-cmd.patch application/octet-stream 5.4 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2008-04-03 08:12:32 Re: Patch queue -> wiki (was varadic patch)
Previous Message Magnus Hagander 2008-04-03 07:12:58 Re: modules

Browse pgsql-patches by date

  From Date Subject
Next Message Bernd Helmle 2008-04-03 08:34:56 Re: psql command aliases support
Previous Message Volkan YAZICI 2008-04-03 06:18:31 Re: Configurable Penalty Costs for Levenshtein