Re: psql questions: SQL, progname, copyright dates - Mailing list pgsql-hackers

I talked to Greg via chat and it looks like '&' is the best choice for
adding system object display:
\d& shows system stuff\df& shows system functionsetc.

Greg is going to work on a patch for 8.1.

---------------------------------------------------------------------------

Bruce Momjian wrote:
> 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@candle.pha.pa.us               |  (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
> 

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