Re: Support for DatabaseMetadata: getCatalogName, getTableName,

On Thu, 4 Jan 2007, Ken Johanson wrote:

> I guess I am not fully understanding why getTableName isn't just being 
> populated with PGResultSetMetaData.getBaseTableName() in the first place; if 
> so please feel welcome to hit me over the head with the cold hard truth ;-)
>

The previous discussion I cited was referring to getColumnName and how it 
really should be referring to the alias of a result, not the column 
itself.  That is for "SELECT a AS b FROM c AS d" should return "b" for 
getColumnName(1).  If we accept that as true then it follows that 
getTableName(1) should return "d", not "c".  Right now we don't have the 
information to return "d" and so we must always return the empty string. 
Getting the base column and table names seems more useful but does not 
appear to be what the javadoc and spec imply as the behavior of the 
standard API methods.

Kris Jurka