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

From Ross Reedstrom
Subject Re: proposal: psql concise mode
Date
Msg-id 20111114221602.GC24723@rice.edu
Whole thread Raw
In response to proposal: psql concise mode  (Josh Kupershmidt <schmiddy@gmail.com>)
Responses Re: proposal: psql concise mode
List pgsql-hackers
On Mon, Nov 07, 2011 at 11:01:39PM -0500, Josh Kupershmidt wrote:
> On Mon, Nov 7, 2011 at 10:04 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> 
> >  I can also see myself turning it on and then going
> > - oh, wait, is that column not there, or did it just disappear because
> > I'm in concise mode?
> 
> Yeah, that would be a bit of a nuisance in some cases.

Well, that specific problem could be fixed with some format signalling,
such as changing the vertical divider, or perhaps leaving it doubled:

Given your test case:
test=# \d+ foo                         Table "public.foo" Column |  Type   | Modifiers | Storage | Stats target |
Description--------+---------+-----------+---------+--------------+-------------a      | integer |           | plain
|             | b      | integer |           | plain   |              |Has OIDs: no
 
Concise output might look like (bikeshed argument: "splat" indicates
columns "squashed" out):test=# \d+ foo                         Table "public.foo" Column |  Type   # Storage
#--------+---------+---------+a      | integer # plain   # b      | integer # plain   #Has OIDs: no
 

or:
 Column |  Type   || Storage |--------+---------++---------+ a      | integer || plain   | b      | integer || plain
|

or even: Column |  Type   || Storage ||--------+---------++---------++ a      | integer || plain   || b      | integer
||plain   ||
 

Ross
-- 
Ross Reedstrom, Ph.D.                                 reedstrm@rice.edu
Systems Engineer & Admin, Research Scientist        phone: 713-348-6166
Connexions                  http://cnx.org            fax: 713-348-3665
Rice University MS-375, Houston, TX 77005
GPG Key fingerprint = F023 82C8 9B0E 2CC6 0D8E  F888 D3AE 810E 88F0 BEDE


pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Measuring relation free space
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dump vs malloc