Обсуждение: column refernce question

Hi, how can I know all the foreign key constrainst that references a particular pk ?

this is on postgres 8.1.4 on suse

thanks for any advice

Hugo

Hugo wrote:
> Hi, how can I know all the foreign key constrainst that references a
> particular pk ?
>
You can try this:

SELECT c_from.relname  AS table,
(SELECT attname FROM pg_catalog.pg_attribute a WHERE
a.attrelid=c_from.oid AND attnum = array_to_string(conkey,',')) AS column
FROM pg_catalog.pg_constraint co
LEFT JOIN pg_catalog.pg_class c ON (co.confrelid = c.oid)
LEFT JOIN pg_catalog.pg_class c_from ON (co.conrelid = c_from.oid)
WHERE c.relname ~ '^foreign_key_table_name_here$';

cheers,
Jonathan