PostgreSql查看當前表的主外鍵關係

標籤：

PostgreSql查看當前表被哪些引用作參考表

-- pg_CONSTRAINT.contype : p(主鍵), f(外鍵), u(唯一), c(檢查)
-- 查看當前表ID
SELECT oid, relname FROM pg_class WHERE relname = ‘syslogfilter‘;
-- 查看引用當前表ID作參考表的主外鍵約束資訊
SELECT * FROM pg_CONSTRAINT WHERE confrelid = ‘24935‘;
-- 查看那些外鍵的名稱
SELECT oid, relname FROM pg_class WHERE oid in
(
SELECT conrelid FROM pg_CONSTRAINT WHERE confrelid = ‘24935‘
);

PostgreSql查看當前表的主外鍵關係