Re: psql questions: SQL, progname, copyright dates

Greg Sabino Mullane wrote:
[ There is text before PGP section. ]
>
[ PGP not available, raw data follows ]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Greg Stark wrote:
> > Well there's always \dtS and \dvS I don't see why typing \dfS is any harder.
> >
> > It would be nice for this to be more visible in the documentation and the \?
> > output though. I've only just found it after months of pulling hair out
> > looking for something just like it
>
> Robert Treat replied:
> > Wow you're not kidding. I've been using postgresql for I don't know how
> > many years and I don't think I'd ever noticed that before. ISTM that we
> > can make \df return only user function and \dfS return the system
> > functions, and this would be consitant with how we handle other options.
> > Just make sure to reword \? out put to make it clear that adding S will
> > show system objects.
>
> So it seems there are two possible solutions to the problem of segregating
> user and system objects: change the order by or change the backslash operators.
> I like the latter way, as it seems consistent with what we already are doing
> (e.g. \dt \di) How about if we change the rest of the \d operators that support
> custom objects to support the "S" option? I would affect the following:
>
> \da \dc \dd \df \do \dT
>
> I would rewrite the \? docs to make this more clear as well.

Agreed it would be nice to more clearly distingush user functions from
system ones, but how? I can't see how 'S' is going to help us because
\dS already shows system tables. Would it be \dfS? What is the logic
to that? Having 'S' be a flag and a command is too confusing.

And what about \dn. Seems showing system schemas vs ordinary schemas
would make sense too. I wonder if just telling to people focus on the
schema name is the best bet.

Another idea is to add a flag to skip system stuff like '-', so \df-
doesn't show system stuff. Same for the others. That does make sense
to me. I know it isn't logical for \d but \d is for storage, while the
others are different in that system tables aren't normally accessed by
users, while system functions/schemas are.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073