Re: libpq:Find Table Name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
Cc: pgsql-interfaces(at)postgresql(dot)org, adam(at)piggz(dot)fsnet(dot)co(dot)uk
Subject: Re: libpq:Find Table Name
Date: 2003-07-14 14:48:08
Message-ID: 1241.1058194088@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-interfaces

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

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Klaus Stefan Gerber 2003-07-14 17:23:33 Compilation Problem
Previous Message Jirka Novak 2003-07-14 13:16:26 Re: Sorting by locale settings on Windows?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Adam Pigg 2003-07-14 20:20:56 Re: libpq:Find Table Name
Previous Message Darko Prenosil 2003-07-14 14:00:56 Re: Connecting - Need Help !