From: | Gilles Darold <gilles(dot)darold(at)dalibo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | psql and pset without any arguments |
Date: | 2013-06-28 23:08:16 |
Message-ID: | 51CE1760.3020208@dalibo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I was looking at psql 8.3 documention about \pset options and saw that
there was the following note :
"Note: It is an error to call \pset without any arguments. In the
future this case might show the current status of all printing options."
I looked backward and forward to find that this note is present in all
versions since 7.1 up to 9.3, maybe it is time to add this little feature.
I've attached a patch to add the usage of the \pset command without any
arguments to displays current status of all printing options instead of
the error message. Here is a sample output:
(postgres(at)[local]:5494) [postgres] > \pset
Output format is aligned.
Border style is 2.
Expanded display is used automatically.
Null display is "NULL".
Field separator is "|".
Tuples only is off.
Title is unset.
Table attributes unset.
Line style is unicode.
Pager is used for long output.
Record separator is <newline>.
(postgres(at)[local]:5494) [postgres] >
To avoid redundant code I've added a new method printPsetInfo() so that
do_pset() and exec_command() will used the same output message, they are
all in src/bin/psql/command.c. For example:
(postgres(at)[local]:5494) [postgres] > \pset null 'NULL'
Null display is "NULL".
(postgres(at)[local]:5494) [postgres] >
The patch print all variables information from struct printTableOpt when
\pset is given without any arguments and also update documentation.
Let me know if there's any additional work to do on this basic patch or
something that I've omitted.
Best regards,
--
Gilles Darold
http://dalibo.com - http://dalibo.org
Attachment | Content-Type | Size |
---|---|---|
psql_pset-v1.patch | text/x-patch | 11.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2013-06-28 23:14:28 | Re: [GENERAL] pg_upgrade -u |
Previous Message | Robert Haas | 2013-06-28 22:14:44 | Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks) |