Home -> Usenet -> comp.databases.theory -> Generalized query to determine the table a query or a view's columns come from?

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

From: professor chen <mydejamail_at_yahoo.co.uk>
Date: 3 Mar 2006 15:32:21 -0800
Message-ID: <1141428741.365079.290190_at_t39g2000cwt.googlegroups.com> 





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 Sat Mar 04 2006 - 00:32:21 CET












Original text of this message