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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
