Re: [HACKERS] SHOW ALL output too wide

2005-12-01 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > Dennis Bjorklund wrote: > >> My motivation is only for the good of postgresql. If the majority want > >> something else then that's what should happen (of course). I'm just > >> stating my view, nothing less and nothing more. > > > I am surprised we ha

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Tom Lane
Bruce Momjian writes: > Dennis Bjorklund wrote: >> My motivation is only for the good of postgresql. If the majority want >> something else then that's what should happen (of course). I'm just >> stating my view, nothing less and nothing more. > I am surprised we have not gotten more comments ab

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Bruce Momjian
Dennis Bjorklund wrote: > My motivation is only for the good of postgresql. If the majority want > something else then that's what should happen (of course). I'm just > stating my view, nothing less and nothing more. I am surprised we have not gotten more comments about it. I personally like the

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Dennis Bjorklund
On Sat, 26 Nov 2005, Bruce Momjian wrote: > See the discussion or really solo request by me for more feedback when > this change was made for 8.1: > > http://archives.postgresql.org/pgsql-patches/2005-06/msg00295.php > > Where were you when I asked? I do not work with postgresql like you

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > 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), An even more general solution i

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Bruce Momjian
Dennis Bjorklund wrote: > On Fri, 25 Nov 2005, Bruce Momjian wrote: > > > > > Is there any use for SHOW except in interactive psql sessions? > > > > There certainly is. Imagine querying for timezone. Also remember that > > pgadmin is a client application that is _not_ psql. > > I should have w

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Martijn van Oosterhout
On Fri, Nov 25, 2005 at 08:25:55PM -0300, Alvaro Herrera wrote: > (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.) Auto-wrapping has been con

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Dennis Bjorklund
On Fri, 25 Nov 2005, Bruce Momjian wrote: > > > Is there any use for SHOW except in interactive psql sessions? > > There certainly is. Imagine querying for timezone. Also remember that > pgadmin is a client application that is _not_ psql. I should have written SHOW ALL, that's the command outp

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Bruce Momjian
Alvaro Herrera wrote: > Dennis Bjorklund wrote: > > > My main problem with SHOW as it is in 8.1 is that the output is so wide > > that it's very hard to read the output. > > > > Is there any use for SHOW except in interactive psql sessions? There certainly is. Imagine querying for timezone. A

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Bruce Momjian
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 ou

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Alvaro Herrera
Dennis Bjorklund wrote: > My main problem with SHOW as it is in 8.1 is that the output is so wide > that it's very hard to read the output. > > Is there any use for SHOW except in interactive psql sessions? Nothing that can't be done by querying pg_settings. -- Alvaro Herrera

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Alvaro Herrera
Bruce Momjian wrote: > Alvaro Herrera wrote: > > Bruce Momjian wrote: > > > Dennis Bjorklund wrote: > > > > > > 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 > > > > cli

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Dennis Bjorklund
On Fri, 25 Nov 2005, Bruce Momjian wrote: > > 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? It could do several things. For example \show could omit the description

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Bruce Momjian
Alvaro Herrera wrote: > Bruce Momjian wrote: > > Dennis Bjorklund wrote: > > > > 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

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Martijn van Oosterhout
On Fri, Nov 25, 2005 at 07:24:13PM -0300, Alvaro Herrera wrote: > OTOH, what's the relationship between \show and Martijn's wide output > patch? Maybe the problem can be solved in a different way. None whatsoever. OTOH, there has been discussion about making use of multiline output if it can be d

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Alvaro Herrera
Bruce Momjian wrote: > Dennis Bjorklund wrote: > > 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 thin

Re: [HACKERS] SHOW ALL output too wide

2005-11-25 Thread Bruce Momjian
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