Skip site navigation (1) Skip section navigation (2)

Re: table name into view

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Vergoz Michael" <mvergoz(at)sysdoor(dot)com>, <frank_lupo(at)email(dot)it>,"pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: table name into view
Date: 2002-06-05 07:12:18
Message-ID: D85C66DA59BA044EB96AB9683819CF61015318@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
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:mvergoz(at)sysdoor(dot)com] 
> Sent: 04 June 2002 17:46
> To: frank_lupo(at)email(dot)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(at)email(dot)it>
> To: "pgadmin-hackers" <pgadmin-hackers(at)postgresql(dot)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(at)postgresql(dot)org
> 

pgadmin-hackers by date

Next:From: frank_lupoDate: 2002-06-05 12:00:53
Subject: depending idea
Previous:From: frank_lupo@email.itDate: 2002-06-04 16:49:20
Subject: Re: table name into view

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group