Metadata for tables, schema, and numeric
| От | Mike Finn |
|---|---|
| Тема | Metadata for tables, schema, and numeric |
| Дата | |
| Msg-id | 01070407563900.01010@birch.tacticalExecutive.com обсуждение исходный текст |
| Ответы |
Re: Metadata for tables, schema, and numeric
|
| Список | pgsql-jdbc |
Using 7.1 the following don't ever seem to return anything
getCatalogName(int)
getSchemaName(int)
getTableName(int)
has this been implemented in a newer version of the JDBC driver
If yes... where to get it?
If no... is it planned?
As well
getPrecision(int)
always returns 0 for type numeric(p,s). I checked the source for the driver
(jdbc2) and it seems to always set this to zero as it is not a type checked
for in the switch list (or cascading if's -- it was yesterday when I checked).
Is this because the backend does not provide this information to a client or
is it simply a matter of little more code to the driver to explicitly check
for a few more types?
gb=> \d customer
Table "customer"
Attribute | Type | Modifier
---------------------------+---------------+----------
seqcustomer | numeric(15,0) | not null
name | text | not null
<other fields>
and executing this query
select customer.seqCustomer from customer
gives the following
getColumnName: seqcustomer
getCatalogName:
getColumnLabel: seqcustomer
getSchemaName:
getTableName:
getPrecision: 0
getScale: 0
Thanks in advance.
Mike
===================
Mike Finn
Tactical Executive Systems
mike.finn-pgsql-jdbc@tacticalExecutive.com
В списке pgsql-jdbc по дате отправления: