Re: libpq:Find Table Name

From: Adam Pigg <adam(at)piggz(dot)fsnet(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: libpq:Find Table Name
Date: 2003-07-14 20:20:56
Message-ID: 200307142120.56216.adam@piggz.fsnet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-interfaces

Excellent....can you point me to anymore info on this, i see that pg7.4 isnt
even in beta yet, is this function available in cvs?

cheers

Adam Pigg

On Monday 14 July 2003 15:48, Tom Lane wrote:
> Christoph Haller <ch(at)rodos(dot)fzk(dot)de> writes:
> >> Has anyone any suggestions on how i can achieve getting the table name
> >> for a
> >> filed in a result without having to parse the sql statement (which i
> >> dont
> >> think wold be easy).
> >
> > I very much doubt there is such thing, because the result may come from
> > a complex join or a function.
>
> There is support for this in PG 7.4, in the form of providing the table
> OID for a column (when it's determinable).
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
adampigg.9p.org.uk
adam(at)piggz(dot)fsnet(dot)co(dot)uk
adam(at)adampigg(dot)9p(dot)org(dot)uk

In response to

Browse pgsql-cygwin by date

  From Date Subject
Next Message Litel Wang 2003-07-15 08:45:10 why can't I find the other schemas in my restored database except public schemas ?
Previous Message Jason Tishler 2003-07-14 18:51:25 Re: Problem starting postmaster on Win XP Home

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Moscatt 2003-07-15 00:55:09 Backend Server v's Frontend Server ?
Previous Message Tom Lane 2003-07-14 14:48:08 Re: libpq:Find Table Name