Re: SHOW TABLES - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: SHOW TABLES
Date
Msg-id 1279298657.1735.38250.camel@ebony
Whole thread Raw
In response to Re: SHOW TABLES  (Bruce Momjian <bruce@momjian.us>)
Responses Re: SHOW TABLES
List pgsql-hackers
On Fri, 2010-07-16 at 12:25 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> > On Fri, 2010-07-16 at 12:16 -0400, Bruce Momjian wrote:
> > 
> > > Really?  What are the other syntaxes?
> > 
> > SHOW TABLES
> 
> That is MySQL?  Do does every other RDBMs also use that, as David
> suggested?

He didn't say it was exactly that syntax. We must retain some common
sense in the discussion.

DB2 uses LIST TABLES
SQLServer and Sybase use sp_ procedures for this
Informix uses INFO TABLES
Ingres uses HELP and HELP TABLE foo
Teradata uses SHOW TABLE foo but no syntax meaning "all tables"

So I think David's actual response was appropriate and accurate: its a
common thing to have easily guessable commands for this.

Search Google for "<myfavouriteDBMS> SHOW TABLES" and you'll see that a
lot of people look for and expect this kind of command to exist.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: SHOW TABLES
Next
From: Brendan Jurd
Date:
Subject: Re: patch: to_string, to_array functions