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, ...; I would like to know that mv2 depends on mv1. I assumed this could be done through pg_depend, but the only dependency I see there for the matviews is the one for the namespace. Clearly this information is stored somehow, as a DROP MATERIALIZED VIEW complains about being referenced by other matviews. Am I missing something in pg_depend or do I need to look in a different system table? Regards Thomas
