Generalized query to determine the table a query or a view's columns come from?

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. Received on Fri Mar 03 2006 - 17:32:21 CST