Re: Support for ResultSetMetaData.getTableName

On Tue, 21 Aug 2007, David Goodenough wrote:

> There was talk about this needing "the new communications protocol", but
> that was some years ago. Are we still awaiting a new version of the
> protocol that support this, or can it be implemented on what it there
> now? By now I am referring to 8.2, but if it is not there, can be it
> added to 8.3?
>

The discussion was focused on the ability of the server to return the
alias of a table as well as the base table name. Because getColumnName
will return "b" for "SELECT a AS b FROM c AS d" we have decided that
getTableName should return "d" instead of "c". Right now the server will
tell the driver about a, b, and c, but not d. So we're sort of waiting
for the server to return "d", but no plans have been made to extend the
protocol to include this information at this point. So you'll have to
keep waiting or use PGResultSetMetaData.getBaseTableName to return "c"
instead of "d".

Kris Jurka