postgreSQL外键引用查询
根据一个表名，查询所有外键引用它的表，以及那些外键的列名key_column_usage（系统列信息表），
pg_constraint（系统所有约束表）
SELECTx.table_name, x.column_nameFROMinformation_schema.key_column_usage xINNER JOIN(SELECTt.relname, a.conname FROMpg_constraint a INNER JOIN pg_class ft ON ft.oid = a.confrelid INNER JOIN pg_class t ON t.oid = a.conrelid WHEREa.contype = 'f' ANDa.confrelid = (select e.oid from pg_class e where e.relname = 'xxx_table') ) tp ON (x.table_name = tp.relname AND x.constraint_name = tp.conname)
页:
[1]