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?
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
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
some generalized SQL that can parse the query or view's definition and
retrieve
the list.