hi,
I'm trying to write some code that can analyze the database structure
and i need a way to discover the composition of a view (the tables and
table.column info).
I've managed to do much of this by querying the pg_views for the
definition and literally parsing the SQL myself, but obviously that has
many limitations unless I impliment a complete SQL parser and that's
beyond the scope of what I want :-)
I'm wondering if PostgreSQL actually reparses the view definition on
each invocation or if it stores the required information in some
accessible place.
My goal is to take a view name as input and output the tables and
columns composing the view.
thanks in advance,
- lex
--
Lex Berezhny <LBerezhny@DevIS.com>