Re: proposal: psql concise mode - Mailing list pgsql-hackers

From Dickson S. Guedes
Subject Re: proposal: psql concise mode
Date
Msg-id CAHHcrerJQ1BamyBJFU00rcmg_PJU4bY-Cvf4OazqwY9WQaoORA@mail.gmail.com
Whole thread Raw
In response to proposal: psql concise mode  (Josh Kupershmidt <schmiddy@gmail.com>)
Responses Re: proposal: psql concise mode
List pgsql-hackers
2011/11/5 Josh Kupershmidt <schmiddy@gmail.com>:
> I'd like to propose a "concise mode" for psql, which users might turn
> on via a \pset option. Concise mode would affect only the output of
> psql's backslash commands. For output results which have some all-NULL
> columns, as in:
>
> test=# \d+ foo
>                         Table "public.foo"
>  Column |  Type   | Modifiers | Storage | Stats target | Description
> --------+---------+-----------+---------+--------------+-------------
>  a      | integer |           | plain   |              |
>  b      | integer |           | plain   |              |
> Has OIDs: no
>
> Concise mode would simply omit the all-NULL columns, so that the
> output would look like this:
>
> test=# \d+ foo
>                         Table "public.foo"
>  Column |  Type   | Storage
> --------+---------+---------
>  a      | integer | plain
>  b      | integer | plain
> Has OIDs: no

Using your example, what if column 'b' has a comment and 'a' not? How
the above output will be displayed?

--
Dickson S. Guedes
mail/xmpp: guedes@guedesoft.net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: [PATCH] optional cleaning queries stored in pg_stat_statements
Next
From: Florian Pflug
Date:
Subject: Re: unaccent extension missing some accents