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

Metadata for tables, schema, and numeric

From: Mike Finn <mike(dot)finn(at)tacticalExecutive(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Metadata for tables, schema, and numeric
Date: 2001-07-04 13:56:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Using 7.1 the following don't ever seem to return anything


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 
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
    getColumnLabel: seqcustomer
    getPrecision: 0
    getScale: 0

Thanks in advance.

Mike Finn
Tactical Executive Systems


pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-07-04 15:06:39
Subject: Re: Metadata for tables, schema, and numeric
Previous:From: Bruce MomjianDate: 2001-07-03 16:41:01
Subject: Re: JDBC Support - prepared Statements?

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