From: | Dimitri Fontaine <dfontaine(at)hi-media(dot)com> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | pgsql-hackers(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Stephen Frost <sfrost(at)snowman(dot)net>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Rob Wultsch <wultsch(at)gmail(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Bernd Helmle <mailings(at)oopsware(dot)de>, Guillaume Lelarge <guillaume(at)lelarge(dot)info>, "jd(at)commandprompt(dot)com" <jd(at)commandprompt(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: SHOW TABLES |
Date: | 2010-07-18 19:28:48 |
Message-ID: | A1A5FCA7-9ADC-48AF-B0E9-72269F14D2DB@hi-media.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Le 18 juil. 2010 à 20:58, Andres Freund a écrit :
> On Sunday 18 July 2010 20:39:07 Dimitri Fontaine wrote:
>> SHOW ANY TABLE
>> GROUP BY tablename
>> HAVING array_agg(attributes) @> array['date'::regtype, 'time'::regtype];
> Why is that in *any* way better than
>
> SELECT *
> FROM meta.tables
> ...
There are two questions here I think, really.
First is about having meta-data queries in the backend, and we want that because we want it to be easy for everybody to have access to those, whether they choose to use psql or whatever else.
Second is about why having SHOW be usable as if it where a "real" SQL query? That's because it's been said that people will certainly want to go further away using the facility. And now they want full SQL.
So it seems to me we're now trying to catch 2 birds with a single 'SHOW' stone.
--
Dimitri Fontaine
PostgreSQL DBA, Architecte
From | Date | Subject | |
---|---|---|---|
Next Message | Dimitri Fontaine | 2010-07-18 19:31:00 | Re: SHOW TABLES |
Previous Message | Dimitri Fontaine | 2010-07-18 19:26:00 | Re: SHOW TABLES |