Re: SHOW TABLES - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: SHOW TABLES
Date
Msg-id 1279209900.30528.20.camel@jd-desktop.unknown.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: Thom Brown
Date:
Subject: Re: SHOW TABLES
Next
From: "Aaron W. Swenson"
Date:
Subject: Re: SHOW TABLES