Re: Dependencies of Matviews?

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