From: Adam Pigg <adam@piggz.fsnet.co.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: libpq:Find Table Name
Date: Mon, 14 Jul 2003 21:20:56 +0100
User-Agent: KMail/1.5.2
Cc: pgsql-interfaces@postgresql.org
References: <3F12981B.CDE42A4A@rodos.fzk.de> <1241.1058194088@sss.pgh.pa.us>
In-Reply-To: <1241.1058194088@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200307142120.56216.adam@piggz.fsnet.co.uk>

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@rodos.fzk.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@postgresql.org so that your
>       message can get through to the mailing list cleanly

-- 
adampigg.9p.org.uk
adam@piggz.fsnet.co.uk
adam@adampigg.9p.org.uk