Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: SHOW ALL output too wide


  • From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
  • To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
  • Cc: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: SHOW ALL output too wide
  • Date: Fri, 25 Nov 2005 19:13:28 -0500 (EST)
  • Message-id: <200511260013(dot)jAQ0DST05693(at)candle(dot)pha(dot)pa(dot)us>

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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group