Re: SHOW ALL output too wide

Dennis Bjorklund wrote:
> I've noticed that in 8.1 the output of SHOW ALL includes a description
> column. This makes the output very wide which makes it hard to use from
> psql (I need to make the terminal window 164 characters wide to not get
> any line wrapping). I wish I would have noticed this before 8.0 was out
> and then I would have voted no.
>
> Also, how come it's not implemented by a \show command in psql that
> queries pg_settings. Then it would work like most other commands. And one
> could have a \show+ command that include the description.

Why implement something in the client if the server supports it cleanly
already.

Try \x to see the output clearer.

>
> Actually, I'm going to implement a \show command and send to -patches and
> then SHOW can even be deprecated (if we want). SHOW is just a command line
> client command, that is implemented in the server. That is not how we
> normally do things in pg (for example, we have \d instead of a server
> DESCRIBE command).

If you remove SHOW then applications/interfaces can't use it, which is
bad.

--
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