Laurenz Thanks for your reply, it is going to help me. I use this query to get the dependencies of view with the objects in the db SELECT * FROM INFORMATION_SCHEMA.view_column_usage I now have to explain the attributes of the join tree, that is JOIN expressions e JOIN clauses. Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/Extracting-data-from-the-view-to-retrieve-the-foreign-key-is-not-declared-tp5795408p5795524.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
