From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
Cc: LBerezhny@DevIS.com
Subject: Re: pg_views
Date: Tue, 04 Feb 2003 10:02:11 +0100
Message-ID: <3E3F8192.376AA9CB@rodos.fzk.de> (raw)
>
> I'm wondering if PostgreSQL actually reparses the view definition on
> each invocation or if it stores the required information in some
> accessible place.
>
The documentation says:
Whenever a query against a view (i.e. a virtual table) is made, the
rewrite system rewrites the user's query to a query that
accesses the base tables given in the view definition instead.
>
> My goal is to take a view name as input and output the tables and
> columns composing the view.
>
I very much doubt this is possible, unless you step deep into
the parser defined in gram.y and scan.l, which is
as you mentioned beyond your scope.
Regars, Christoph
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: ch@rodos.fzk.de, LBerezhny@DevIS.com
Subject: Re: pg_views
In-Reply-To: <3E3F8192.376AA9CB@rodos.fzk.de>
* 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