Re: SHOW TABLES

On Thu, 2010-07-15 at 18:02 +0200, Guillaume Lelarge wrote:

> > I have to agree with Simon here. \d is ridiculous for the common user.
> > 
> > SHOW TABLES, SHOW COLUMNS makes a lot of sense. Just has something like
> > DESCRIBE TABLE foo makes a lot more sense than \d.
> > 
> 
> And would you add the complete syntax? I mean:
> 
>   SHOW [OPEN] TABLES [FROM db_name] [LIKE 'pattern']
> 
> I'm wondering what one can do with the [FROM db_name] clause :)

Well I hadn't thought it out fully. I was just shutting down somebody
elses idea that the feature had no legs. Which is obviously, not true.

Let the discussion bloom :D

JD

-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering