From: | Doug Bloebaum <blabes(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Viewing non-system objects in psql |
Date: | 2005-06-17 15:04:08 |
Message-ID: | caa2de8a05061708046de5e77b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 6/16/05, David Fetter <david(at)fetter(dot)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!
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Browne | 2005-06-17 15:25:02 | Re: PostgreSQL Certification |
Previous Message | Bruce Momjian | 2005-06-17 14:58:30 | Change to make strings SQL-standard |