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

Re: Support for ResultSetMetaData.getTableName

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Support for ResultSetMetaData.getTableName
Date: 2007-08-27 05:53:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc

On Mon, 27 Aug 2007, Tom Lane wrote:

> I suggest that the following mapping might be more sensible:
> 	getColumnName		returns "a"
> 	getTableName		returns "c"
> 	getSchemaName		returns name of c's schema
> 	getColumnLabel		returns "b"
> where the first three fail if the SELECT column isn't a simple column
> reference, but getColumnLabel always works.

I tried that back here:

and continuing here:

This message demonstrates that many other drivers do Column Name/Label in 
a different way:

So while I agree with you that the above suggestions make sense from a 
blank slate, we can't do this without causing problems.  It seems people 
would like us to fallback from our position of table and schema returning 
aliases, which while inconsistent, is certainly more useful at this point 
in time.

Kris Jurka

In response to


pgsql-jdbc by date

Next:From: Marek LewczukDate: 2007-08-27 07:35:54
Subject: small correction to AbstractJdbc2Array
Previous:From: Tom LaneDate: 2007-08-27 05:31:16
Subject: Re: Support for ResultSetMetaData.getTableName

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