pg_views

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(at)DevIS(dot)com>