Sam Mason wrote on 27.08.2009 21:51:
The information is all in the system catalogs; I've not had much
opportunity to fiddle with them so far but the following may be a start
to help get things out for you.
SELECT c.relname, a.attname, t.relname
FROM pg_class c, pg_depend d, pg_class t, pg_attribute a
WHERE c.relkind = 'S'
AND d.objid = c.oid
AND d.refobjid = t.oid
AND (d.refobjid,d.refobjsubid) = (a.attrelid,a.attnum);
Ah great, I didn't realize I could use pg_depend for this.
Thanks, works like a charm! This is exactly what I was looking for.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
