Re: psql's \d commands --- end of the line for 1-character identifiers?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql's \d commands --- end of the line for 1-character identifiers?
Date: 2002-12-09 21:22:20
Message-ID: 015301c29fc9$0f076160$6500a8c0@internal
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> ... and that was already proposed for "show schemas" (namespaces).
>
> I'm inclined to think it's time to bite the bullet and go over to
> words rather than single characters to identify the \d target
> (viz, "\dschema", "\dcast", etc, presumably with unique abbreviations
> being allowed, as well as special cases for the historical single
> characters).

Hmmm...I'm not certain that the \d commands really NEED to have a logical
link to the actual thing you're listing. If you just made \dh for schemas,
people would look it up and then remember it from then on. It's probably
not a huge deal.

We could do DESCRIBE commands as well. Also, what happened to the
INFORMATION_SCHEMA proposal? Wasn't Peter E doing something with that?
What happened to it?

> The issue here is what do we do with the existing "\d[istvS]" behavior
> (for instance, "\dsit" means "list sequences, indexes, and tables").
> Is that useful enough to try to preserve, or do we just bit-bucket it?
> If we do try to preserve it, how should it work?

I'd much rather it were preserved, and I'm sure most people would as well.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2002-12-09 21:25:12 Re: psql's \d commands --- end of the line for
Previous Message Tom Lane 2002-12-09 21:19:54 Re: Sequence Cleanup

Browse pgsql-patches by date

  From Date Subject
Next Message Hannu Krosing 2002-12-09 21:25:12 Re: psql's \d commands --- end of the line for
Previous Message Jon Jensen 2002-12-09 21:05:54 Refuse SSL patch