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
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
I'm so close but I can't quite figure out how to match view columns to
their source columns in a query. Looks like I might need yet another
table to join that makes that match, but I'm not having any success
finding such a bridge. Matching views to their source tables works well
enough. What
