Re: Missing functionality in ResultSetMetaData ?

Check the archives, there's no way for us to get the tables.

The problem is that the server doesn't tell us what the table is that
the column came from

consider select a as newcol from foo;

we don't get the column a back from the server.

Dave
On 9-Aug-05, at 4:38 PM, Thomas Dudziak wrote:

> Hi,
>
> I'm trying to extract the source tables from a result set for a
> arbitrary select query. For this I use the
>
> ResultSetMetaData.getTableName(int columnIndex)
>
> method. However with the postgresql-8.0-311.jdbc3.jar driver against a
> PostgreSQL 8.0.1, I never get any table names, regardless of whether
> the query is a straight SELECT * FROM simpletable or a complicated
> query using multiple joins.
> Are there plans to incorporate this functionality, or perhaps a driver
> version that already supports this ?
>
> regards,
> Tom
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: 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
>
>