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 |
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 |
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 |