Re: ResultSetMetaData.getTableName() == null - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: ResultSetMetaData.getTableName() == null
Date
Msg-id 451354B5.2070701@opencloud.com
Whole thread Raw
In response to Re: ResultSetMetaData.getTableName() == null  (Philip Yarra <philip@utiba.com>)
Responses Re: ResultSetMetaData.getTableName() == null  (Philip Yarra <philip@utiba.com>)
List pgsql-jdbc
Philip Yarra wrote:

> I don't know why it returns "" - perhaps someone else can answer that.
> Mind you, Oracle 10g does the same. Sybase ASE 12.5 is the only DB I
> have access to where I get a non-empty table name.

There was a long discussion about this some time ago, see
http://archives.postgresql.org/pgsql-jdbc/2004-08/msg00023.php or
thereabouts which is when we started agreeing on things :)

Essentially I think it boiled down to "getTableName() should return the
table alias name", and since we don't have that available we return "".
There's a postgresql-specific interface to get at the underlying table
name (in the cases where that info is available).

-O

pgsql-jdbc by date:

Previous
From: Philip Yarra
Date:
Subject: Re: ResultSetMetaData.getTableName() == null
Next
From: Philip Yarra
Date:
Subject: Re: ResultSetMetaData.getTableName() == null