column refernce question

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