Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group