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.
