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
>
> 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
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 definit
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 compo