Thread: table name into view

table name into view

From
"frank_lupo@email.it"
Date:
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

Re: table name into view

From
"Vergoz Michael"
Date:
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


Re: table name into view

From
"frank_lupo@email.it"
Date:
> 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
>
>
Please send me a example

Bye !!
Frank Lupo (Wolf) !!



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Stufo dei soliti film in videocassetta? Partecipa al grande concorso di
QXservice e prova a vincere un favoloso Lettore DVD Philips:
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=538&d=4-6

Re: table name into view

From
"Dave Page"
Date:
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
>