Re: SHOW ALL output too wide

[Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>]

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