Re: PGResultSetMetaData

Leo,

Here is the documentation of the interface

/**
* Returns the underlying table name of query result, or ""
* if it is unable to be determined.
*
* @since 8.0
*/
public String getBaseTableName(int column) throws SQLException;

/**
* Returns the underlying table name of query result, or ""
* if it is unable to be determined.
*
* @since 8.0
*/
public String getBaseSchemaName(int column) throws SQLException;

So I'm guessing your query makes it difficult to find the table names
and the schema names.

What is your query?

Dave

leo wrote:

>Chris Smith:
>
>
>> ResultSet rs = stmt.executeQuery(...);
>> ResultSetMetaData rmd = rs.getMetaData();
>>
>> String table = rmd.getTableName(1);
>> String schema = rmd.getSchemaName(1);
>>
>>
>Does this really work?
>
>Using Postgres 8 i am getting empty strings from both methods.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
>
>

--
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561