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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
