On 07/18/2010 08:58 PM, Andres Freund wrote:
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
...
Oh. The second looks like something I know. Oh. My editor maybe as well? Oh.
And some other tools also?
Your syntax also forgets that maybe I only need a subset of the information.
I am quite a bit surprised about all this discussion. I have a very hard time
we will find anything people agree about and can remember well enough to be
usefull for both manual and automatic processing.
I agree that the internal pg_* tables are not exactly easy to query. And that
the information_schema. ones arent complete enough and have enough concept
mismatch to be confusing. But why all this?
exactly my thoughts - but as I said earlier maybe this is actually an
opportunity to look at newsysviews again?
Stefan
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
