Re: Support for DatabaseMetadata: getCatalogName, getTableName,

Kris Jurka wrote:
>
>
> On Thu, 4 Jan 2007, Ken Johanson wrote:
>
>> These will be in the java.sql.ResultSetMetaData interface's
>> implementation? Or would I need to obtain a PGResultSetMetaData (which
>> doesn't seem to extend RSMD; does a facade RSMD impl class wrap
>> PGResultSetMetaData?)?
>>
>
> ResultSet rs = Statement.executeQuery("SELECT a, b FROM tab");
> ResultSetMetaData rsmd = rs.getMetaData();
> org.postgresql.PGResultSetMetaData pgrsmd =
> (org.postgresql.PGResultSetMetaData)rsmd;
> for (int i=1; i<=rsmd.getColumnCount(); i++) {
> System.out.println(pgrsmd.getBaseTableName(i));
> }
>
> Kris Jurka
>
>

Kris, I'm sorry, I meant, will I be able to get the table name via
ResultSetMetaData.getTableName(int). The app I'm using internally
depends on standard interfaces at its core and unfortunately I don't
have the ability (nor desire really) to add in impl-specific code.

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 ;-)

Thank you again,
Ken