On 02/26/2016 11:51 AM, David G. Johnston wrote:
On Fri, Feb 26, 2016 at 12:15 PM, Leonardo M. Ramé <l.rame@xxxxxxxxxxx
<mailto:l.rame@xxxxxxxxxxx>>wrote:
El 26/02/16 a las 15:59, Leonardo M. Ramé escribió:
It looks like psql 9.4.4 has a bug when trying to display table info
using \d tablename.
On 9.4.2 that command displays Indexes, Constraints, Triggers, etc.
9.4.4 only displays the table fields.
Regards,
Sorry, option \t (Tuples Only) must be off to display that info.
This is surprising (to me).
--tuples-only:
Turn off printing of column names and result row count footers, etc.
I guess that falls under "etc." but still...
I always thought of it that while the \d command had to run queries to
obtain its data the output was basically a pre-defined screen that could
be influenced by adding a "+" to the command but it otherwise operated
independently of the other style-oriented commands. So, I could choose
to run my queries under whatever settings I desired but if I need to
access the data dictionary for help I wouldn't have to turn off
tuples-only just to see some additional info and then turn it back on
when I run my query.
The fuller description of what happens is here:
http://www.postgresql.org/docs/9.4/interactive/app-psql.html
\pset [ option [ value ] ]
tuples_only (or t)
If value is specified it must be either on or off which will enable
or disable tuples-only mode. If value is omitted the command toggles
between regular and tuples-only output. Regular output includes extra
information such as column headers, titles, and various footers. In
tuples-only mode, only actual table data is shown.
That said I do little interactive work with psql - I much prefer a
non-CLI application for ad-hoc work - so maybe linking the two has
value. But to me at least I am a bit surprised.
David J.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
