Re: Support for DatabaseMetadata: getCatalogName, getTableName,

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