Andreas Joseph Krogh <[EMAIL PROTECTED]> writes:
> AFAICS this lists all tables which have a column named '?', which is not what
> I'm after. I'm after listing all columns referencing a certain column as a
> FOREIGN KEY.
Should be possible to dredge that out of pg_constraint ... about like
this:
select confrelid::regclass, af.attname as fcol,
conrelid::regclass, a.attname as col
from pg_attribute af, pg_attribute a,
(select conrelid,confrelid,conkey[i] as conkey, confkey[i] as confkey
from (select conrelid,confrelid,conkey,confkey,
generate_series(1,array_upper(conkey,1)) as i
from pg_constraint where contype = 'f') ss) ss2
where af.attnum = confkey and af.attrelid = confrelid and
a.attnum = conkey and a.attrelid = conrelid;
Deconstructing those arrays in parallel is a bit of a pain :-(
regards, tom lane
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
