| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Thom Brown <thombrown(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: SHOW TABLES |
| Date: | 2010-07-15 23:19:47 |
| Message-ID: | 20100715231947.GA30063@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jul 15, 2010 at 02:31:10PM -0400, Alvaro Herrera wrote:
> Excerpts from Peter Eisentraut's message of jue jul 15 14:21:26 -0400 2010:
> > On tor, 2010-07-15 at 17:35 +0100, Simon Riggs wrote:
> > > There should be one command to "display a list of tables" and it needs
> > > to be easily guessable for those who have forgotten.
> >
> > Well, if you put information_schema in the default path, it'd be
> >
> > SELECT * FROM TABLES;
>
> Or even
>
> TABLE TABLES;
>
> weird though that is ...
"Weird though that is," is *exactly* the problem we're trying to
address here. SHOW TABLES is really, really easy to remember or
guess.
Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2010-07-15 23:57:42 | buildfarm housekeeping / planning |
| Previous Message | Andrew Dunstan | 2010-07-15 22:09:41 | buildfarm owners, please add REL9_0_STABLE to your list of builds |