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

Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ken Johanson <pg-user(at)kensystem(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel
Date: 2006-12-29 16:15:57
Message-ID: 674F8180-BA35-4CBA-9A4E-2A8EBDE0B095@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
I stand corrected. I'll try to find some time this week to work on  
some of the outstanding issues.

Tom, as of which version has this been implemented ?

Dave
On 29-Dec-06, at 10:47 AM, Tom Lane wrote:

> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>> The backend does not provide us with this information, so it is not
>> trivial to implement( or even possible in some cases) .
>
> Huh?  We added table oid and column number to the RowDescription  
> message
> specifically to support those JDBC methods.  You would have to  
> incur an
> additional round trip to the server to get names from these numbers,
> but it's certainly implementable ... and I thought it'd been  
> implemented
> long ago, so I'm a bit surprised by Ken's report.
>
> As for getCatalogName, I think just returning the database name (which
> you should still have from the connection request) would meet the  
> spec.
>
> 			regards, tom lane
>


In response to

Responses

pgsql-jdbc by date

Next:From: Tom LaneDate: 2006-12-29 16:21:29
Subject: Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel
Previous:From: Tom LaneDate: 2006-12-29 15:47:02
Subject: Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel

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