Search Postgresql Archives

Re: Possible bug in psql 9.4.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Feb 26, 2016 at 12:15 PM, Leonardo M. Ramé <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.

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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux