Suppose I have a view: create view v1 as select * from t1;
and another view as: create view v2 as select * from v1; Now is there any query or any catalog table available by which I can get to know the dependency (names of views on which v2 depends) for view v2? I did check the pg_views but cant seem to get a simple output from it which should be like this: view_name | dependent_views v1 | v2 | v1 -- Shoaib Mir EnterpriseDB (www.enterprisedb.com)