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