Re: Display View Columns and Their Source Tables and Columns

2019-04-21 Thread Laurenz Albe
Susan Hurst wrote: > I'm so close but I can't quite figure out how to match view columns to > their source columns in a query. There is no simple way to find which view column matches which column in the original table. Don't forget that the column could be defined as an expression that involves

Re: Display View Columns and Their Source Tables and Columns

2019-04-21 Thread legrand legrand
Hi, I don't know if it is possible ... the only way I found seems to use pg_depend and pg_rewrite as described here https://pgdba.org/post/2018/04/dependency_ladder/ Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html