Re: PGResultSetMetaData - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: PGResultSetMetaData
Date
Msg-id 41F404BA.2020801@fastcrypt.com
Whole thread Raw
In response to Re: PGResultSetMetaData  (leo <usenet@workfile.de>)
List pgsql-jdbc
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@postgresql.org so that your
>      message can get through to the mailing list cleanly
>
>
>
>

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


pgsql-jdbc by date:

Previous
From: leo
Date:
Subject: Re: PGResultSetMetaData
Next
From: Oliver Jowett
Date:
Subject: Re: PGResultSetMetaData