Re: SHOW TABLES - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: SHOW TABLES
Date
Msg-id 1279481726.25158.6750.camel@ebony
Whole thread Raw
In response to Re: SHOW TABLES  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
On Sun, 2010-07-18 at 20:39 +0200, Dimitri Fontaine wrote:

> SHOW TABLE foo;

Yes

> SHOW TABLES WHERE tablename ~ 'foo';
> 
> SHOW ANY TABLE
> GROUP BY tablename 
>   HAVING array_agg(attributes) @> array['date'::regtype,
> 'time'::regtype]; 

For me, realistically, No. 

Simplifying SQL should be left to the SQL standards committee. It could
certainly use a hand there, but its too big a mountain too climb, for
me.

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



pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: SHOW TABLES
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: SHOW TABLES