Re: Viewing non-system objects in psql

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!