Re: SHOW TABLES - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: SHOW TABLES
Date
Msg-id 1279209900.30528.20.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: SHOW TABLES  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: SHOW TABLES
Next
From: "Joshua D. Drake"
Date:
Subject: Re: SHOW TABLES