From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Brendan Jurd <direvus(at)gmail(dot)com>, Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: FWD: Re: Updated backslash consistency patch |
Date: | 2009-01-15 17:54:53 |
Message-ID: | 200901151754.n0FHsrg18619@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> I think people use \df all the time to check the argument list, verify
> >> whether they remember the function name correctly, etc. It's not for
> >> "learning about" stuff you never heard of, it's for remembering details
> >> (as indeed is the usage for user-defined functions too).
>
> > Which means my patch will work perfectly for them (because of the
> > pattern), and hopefully for you. ;-)
>
> I can agree that it's reasonable for the default behavior with no
> arguments (no pattern) to be to show only user-defined objects.
> Otherwise you're going to get quite a long list, which doesn't
> seem particularly useful --- and if you really want that, you can
> say '*.*' so there's no loss of functionality if we change it.
>
> However, if we don't have that restriction when a pattern is given,
> I wonder whether we need the 'S' modifier at all. If you really
> want to see only system objects, there's 'pg_catalog.*', but this
> doesn't seem like a case that's so common that it needs a command
> modifier letter.
>
> So my proposal at the moment is to get rid of 'S', have the behavior
> with a pattern be the same as it was before, and only change the
> behavior with no pattern.
Well, this is psql and it should be easy; I am not sure pg_catalog.*
fits that requirement. Right now if you do \dt you see user tables, and
\dtS shows system tables; I don't see removing 'S' as being a great
usability gain.
I think searching for both user and system stuff with a pattern is a
no-brainer.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-01-15 17:55:11 | Re: FWD: Re: Updated backslash consistency patch |
Previous Message | Simon Riggs | 2009-01-15 17:51:35 | Re: BUG #4566: pg_stop_backup() reports incorrect STOP WAL LOCATION |