Re: [HACKERS] psql's \d commands --- end of the line for 1-character identifiers?
Christopher Kings-Lynne writes: 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? Ooops. Yeah, let's get this in. Where should I put it? -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] psql's \d commands --- end of the line for 1-character identifiers?
Peter Eisentraut [EMAIL PROTECTED] writes: Christopher Kings-Lynne writes: 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? Ooops. Yeah, let's get this in. Where should I put it? How do you mean where? The spec says it's gotta be called information_schema, no? What's left to decide? regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] psql's \d commands --- end of the line for 1-character identifiers?
[ moved to hackers from pgsql-patches ] Christopher Kings-Lynne [EMAIL PROTECTED] writes: Peter wrote: Christopher Kings-Lynne writes: \dc - list conversions [PATTERN] \dC - list casts What are we going to use for collations? \dn Is the only letter left in collations that hasn't been used! ... 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). 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? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] psql's \d commands --- end of the line for 1-character identifiers?
... 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 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] psql's \d commands --- end of the line for 1-character
Christopher Kings-Lynne wrote: 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. I was going to say the opposite, that it isn't needed. Oh well. -- 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 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])