Re: psql questions: SQL, progname, copyright dates

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(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 16:23:48
Message-ID: 200409091623.i89GNms23388@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > I talked to Greg via chat and it looks like '&' is the best choice for
> > adding system object display:
>
> > \d& shows system stuff
>
> Yech, that's awful. It looks ugly and it commandeers a punctuation
> symbol that we might wish to use for something else someday.
>
> I thought the "S" suggestion was much better than this.

My problem is that it uses a letter as a modifier, while all other
letters are object specifications. '+' is a modifier. We need another
modifier that isn't a letter. No one knew \dtS worked because 'S'
doesn't look like a modifier.

> Personally I am not unhappy with the existing behavior, because (unlike
> Greg I guess) I use \df and \do to look at system definitions all the
> time. However I'm willing to accept \dfS on the grounds of symmetry
> with the behavior for tables. I don't really want to put up with a less
> convenient behavior *and* a gratuitously different syntax.

I am also happy with the existing behavior. Another idea is to add a
modifier that supresses system functions, etc.

I think adding 'S' to \df confuses more than it helps.

--
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:31:55 Re: row wise comparison broken
Previous Message Thomas F.O'Connell 2004-09-09 16:14:54 Re: pg_autovacuum and v8.0