Shoaib Mir escribió: > 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?
Yes, pg_depend has a row for v2 to indicate dependency on the pg_rewrite row, which in turn has an entry to indicate dependency on v1. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
