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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073