Is there way to determine the table a query or a view's columns come from?
I am looking for something like that in postgresql. If it doesn't exist is there
some generalized SQL that can parse the query or view's definition and retrieve
the list.
something like
column name | actual column name | source table | actual source table
column name is either the original name or an alias for it, and so is source
table.
