Re: Viewing non-system objects in psql

On 6/16/05, David Fetter <david@fetter.org> wrote:
> 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 :)
>

Thumbs up from me, too.  It fails the test of "least astonishment" for
me when I get a listing of all the system functions with a \df, no
matter how many times I do it.  I like the \dfS model!