Re: SHOW TABLES

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: David Fetter <david(at)fetter(dot)org>
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-16 00:37:19
Message-ID: 1279240412-sup-2844@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Excerpts from David Fetter's message of jue jul 15 19:19:47 -0400 2010:
> On Thu, Jul 15, 2010 at 02:31:10PM -0400, Alvaro Herrera wrote:

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

Eh? I thought the problem being solved is that the command is
implemented in the client side rather than the server side, so all
interfaces need to implement it time and time again. With TABLE TABLES
there's no such problem.

TABLE has also the advantage (over SHOW) that it already works on 8.4,
and moreover it is SQL standard.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-07-16 00:46:22 Re: small exclusion constraints patch
Previous Message Boxuan Zhai 2010-07-16 00:26:13 Re: gSoC - ADD MERGE COMMAND - code patch submission