From: Prime Ho <ho@optimasoft.com.tw>
To: pgsql-sql@postgresql.org
Subject: get source table.field name from view's field
Date: Fri, 8 Nov 2002 13:17:52 +0800
Message-ID: <aqfhcb$26u0$1@news.hub.org> (raw)
Hi,
Firstly , sorry about my poor english, I'll do my best to explain what I
want.
Actually, in most cases, We do query via view, in order to improve
the query speed, we'll create index in physical table field that is mapped
in view's where statement. So, I got an idea to store view statement in a
DataDictionay,
while I maintain the DataDictionary's sql statement, program will trigger a
function
to parse the sql statement, and create index in relative table field
automatically.
So, the problem is how to get the source table & field name for create
index,
could it achieve by oid or postgresql already have function to do that?
Regards,
Ho.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ho@optimasoft.com.tw
Subject: Re: get source table.field name from view's field
In-Reply-To: <aqfhcb$26u0$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox