Re: SHOW ALL output too wide

Alvaro Herrera wrote:
> > > I think a \show would be nice, but deprecating SHOW is out of the
> > > question.  (The pg_settings view is a perfect replacement AFAICS but I
> > > doubt we can get rid of the old interface.)
> > > 
> > > OTOH, what's the relationship between \show and Martijn's wide output
> > > patch?  Maybe the problem can be solved in a different way.
> > 
> > What does \show do that SHOW does not?
> 
> Well, nothing given that it isn't implemented yet :-)  But if I
> understood Dennis' proposal, the idea was that the output would be
> nicely formatted instead of wrapping.

Well, that's hardly a reason to add something to the client that is
already in the backend.  A much more general solution would be to either
add a flag to SHOW ALL to supress the extra column (or one to add it),
or auto-\x for wide output.  Hacking in \show is not the solution. 
There was a long discussion about outputing the description for SHOW. 
Originally SHOW always showed the description, but the agreed behavior
was that only SHOW ALL would show it.

> (I just noticed that Martijn's patch is not about auto-wrapping but
> about displaying \n correctly, which is quite different.  So while there
> may be some common code it certainly is not the same thing.)

Right.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073