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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
