Re: psql questions: SQL, progname, copyright dates

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: psql questions: SQL, progname, copyright dates
Date: 2004-09-09 15:33:40
Message-ID: 200409091533.i89FXep16180@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 functions
etc.

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(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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-09-09 16:08:40 Re: psql questions: SQL, progname, copyright dates
Previous Message Tatsuo Ishii 2004-09-09 14:09:01 row wise comparison broken