Using the Postgres
information_schema or system catalogs, is it possible to determine what table columns are referenced by the columns in a view?
information_schema.view_column_usage provides information on columns that are used in a view, not necessarily selected as a column.
pg_attribute provide some info, but there doesn't seem to be a way to map columns from a view where an alias has been used.
Is is it possible to get the column references of the selected columns in a view?