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. Also remember that pgadmin is a client application that is _not_ psql. > Nothing that can't be done by querying pg_settings. True, so we have pg_settings and SHOW. I see no reason for a third, \show. -- 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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org