Tom Lane wrote:
> Dave Cramer <pg@fastcrypt.com> writes:
>
>>The problem is that the server doesn't tell us what the table is that
>>the column came from
>>consider select a as newcol from foo;
>>we don't get the column a back from the server.
>
>
> Uh, that is there in protocol 3.0 ...
Dave has it backwards; the issue is that for:
SELECT * FROM foo f
the protocol tells us the result columns come from table 'foo'; but
JDBC's getTableName() should return the alias 'f', which we don't
generally know.
-O