New answers tagged dependencies
The first three FD's combine to give MNOP -> L so MNOP is one possible candidate key, CK1. Similarly the last three FD's combine to give NOPL -> M so NOPL is another possible candidate key, CK2. However CK1 and CK2 have columns NOP in common, making them overlapping candidate keys.
here's a quick and ugly query that make the job : with nsp_oid as ( select oid from pg_namespace where nspname='mySchema' ), dep_oid as ( select p.objid as oid from pg_depend p join nsp_oid n on refobjid = n.oid ), rew_oid as( select p.objid as oid from pg_depend p join dep_oid d on p.refobjid = d.oid where ...
You can use pg_depend table to resolve that : select objid::regclass from pg_depend where refobjid = (select oid from pg_namespace where nspname='mySchema');
Top 50 recent answers are included