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)