Skip site navigation (1) Skip section navigation (2)

Re: Missing functionality in ResultSetMetaData ?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Thomas Dudziak <tomdzk(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Missing functionality in ResultSetMetaData ?
Date: 2005-08-09 21:10:33
Message-ID: B5486749-C63D-4136-A3C0-64DC1FAF6CAD@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>
>


In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-08-09 21:12:36
Subject: Re: Missing functionality in ResultSetMetaData ?
Previous:From: Thomas DudziakDate: 2005-08-09 20:38:12
Subject: Missing functionality in ResultSetMetaData ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group