Reading the system tables won't help. You will need to parse the SQL returned by pg_get_viewdef to get the underlying table names.
Regards, Dave. > -----Original Message----- > From: Vergoz Michael [mailto:[EMAIL PROTECTED]] > Sent: 04 June 2002 17:46 > To: [EMAIL PROTECTED]; pgadmin-hackers > Subject: Re: [pgadmin-hackers] table name into view > > > your have to read the system table. > > Best regards, > Vergoz Michael > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "pgadmin-hackers" <[EMAIL PROTECTED]> > Sent: Tuesday, June 04, 2002 6:31 PM > Subject: [pgadmin-hackers] table name into view > > > > If possible to retrive tables name of definitions view? > > The functions pg_get_viewdef retrive the CREATE VIEW command. > > > > Bye !! > > Frank Lupo (Wolf) !! > > > > > > > > -- > > Prendi GRATIS l'email universale che... risparmia: > > http://www.email.it/f > > > > Sponsor: > > Il modo pi� semplice e conveniente per mandare bouquet e > composizioni > floreali in tutta Italia. > > Rapporto personalizzato con il Tuo fiorista, ad i prezzi > pi� bassi del > Web. > > La qualit� � garantita! > > > > Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=367&d=4-6 > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 5: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
