Tom Lane schrieb am 23.06.2020 um 23:25:
I would like to extract the dependency between materialized views. e.g. in the following situation: create materialized view mv1 as select ....; create materialized view mv2 as select ... from mv1, ...;or more readably, regression=# select pg_describe_object(classid,objid,objsubid) as obj, pg_describe_object(refclassid,refobjid,refobjsubid) as ref, deptype from pg_depend where objid >= 58550 or refobjid >= 58550;
Ah, great. That's what I was looking for, thanks Thomas
