On 3rd of October, Robert Haas committed patch:
psql: Make \pset without arguments show all settings. Gilles Darold, reviewed by Pavel Stehule
I am sucker for psql enhancements. That's mostly because I am using psql all the time, so any bit of change has huge effect on me.
When you're in psql, you have at least three different “set" commands:
- SET – changes settings on server side – so called GUCs
- \pset – changes output formatting of results
- \set – changes behavior of psql, or sets custom variables
For the first and second – we had a way to see all settings – “SHOW ALL" or “\set".
But there was no such way for \pset. Now, we have it (well, we'll have it, once 9.4 will get released).
How this works? That's simple:
$ \pset Border style (border) is 1. Target width (columns) unset. Expanded display (expanded) is off. Field separator (fieldsep) is "|". Default footer (footer) is on. Output format (format) is aligned. Line style (linestyle) is ascii. Null display (null) is "[null]". Locale-adjusted numeric output (numericlocale) is off. Pager (pager) is always used. Record separator (recordsep) is <newline>. Table attributes (tableattr) unset. Title (title) unset. Tuples only (tuples_only) is off.
Is it good? Well, it's definitely better than nothing. I would prefer to get the output like:
Name | Setting | Description ---------------+-------------+-------------------------------- border | 1 | Border style columns | unset | Target width expanded | off | Expanded display fieldsep | "|" | Field separator footer | on | Default footer format | aligned | Output format linestyle | ascii | Line style null | "[null]" | Null display numericlocale | off | Locale-adjusted numeric output pager | always used | Pager recordsep | <newline> | Record separator tableattr | unset | Table attributes title | unset | Title tuples_only | off | Tuples only
But even as is, it's helpful. Thanks guys.