"Shoaib Mir" <shoaibmir@xxxxxxxxx> writes: > 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? If you get up-close-n-personal with pg_depend you can determine that. regards, tom lane