Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel
Дата
Msg-id 2557.1167407222@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel  (Dave Cramer <pg@fastcrypt.com>)
Ответы Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Dave Cramer <pg@fastcrypt.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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel