Reading the system tables won't help. You will need to parse the SQL returned by pg_get_viewdef to get the underlying
tablenames.
Regards, Dave.
> -----Original Message-----
> From: Vergoz Michael [mailto:mvergoz@sysdoor.com]
> Sent: 04 June 2002 17:46
> To: frank_lupo@email.it; pgadmin-hackers
> Subject: Re: [pgadmin-hackers] table name into view
>
>
> your have to read the system table.
>
> Best regards,
> Vergoz Michael
>
> ----- Original Message -----
> From: <frank_lupo@email.it>
> To: "pgadmin-hackers" <pgadmin-hackers@postgresql.org>
> 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
> majordomo@postgresql.org
>
