Re: Viewing non-system objects in psql - Mailing list pgsql-general

From David Fetter
Subject Re: Viewing non-system objects in psql
Date
Msg-id 20050617023149.GB10795@fetter.org
Whole thread Raw
In response to Viewing non-system objects in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Viewing non-system objects in psql
List pgsql-general
On Thu, Jun 16, 2005 at 07:54:29PM -0000, Greg Sabino Mullane wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I recently submitted a patch that makes all the database objects
> behave in the same way as far as the backslash psql commands.
> Currently, tables work like this: \dt lists all non-system tables in
> your path, while \dtS shows only the system tables. The idea is to
> expand that functionality to other database objects, e.g. functions.
> Currently, \df will show you a list of *all* functions, including
> the system ones. Since there are currently over 1500 system
> functions, this limits its usefullness. The patch standardizes
> everything on the way we do tables and indexes - the user ones are
> shown by default, and you add a capital "S" if you really want to
> see the system ones. So the patch would have \df show all your
> functions, \dD show all your domains, \doS shows the system
> operators, etc.

+1 :)

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-general by date:

Previous
From: David Pratt
Date:
Subject: Advice on structure /sequence / trigger
Next
From: Greg Stark
Date:
Subject: Re: Advice on structure /sequence / trigger