pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christoph Haller <ch@rodos.fzk.de>
Cc: pgsql-interfaces@postgresql.org
Cc: adam@piggz.fsnet.co.uk
Subject: Re: libpq:Find Table Name
Date: Mon, 14 Jul 2003 10:48:08 -0400
Message-ID: <1241.1058194088@sss.pgh.pa.us> (raw)
In-Reply-To: <3F12981B.CDE42A4A@rodos.fzk.de>
References: <3F12981B.CDE42A4A@rodos.fzk.de>

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



view thread (6+ messages)  latest in thread

Message-ID: <1241.1058194088@sss.pgh.pa.us>
Permalink:  ../1241.1058194088@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1241.1058194088@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: tgl@sss.pgh.pa.us, ch@rodos.fzk.de, adam@piggz.fsnet.co.uk
  Subject: Re: libpq:Find Table Name
  In-Reply-To: <1241.1058194088@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox