From: | dmp <danap(at)ttc-cmc(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Array Char/VarChar Size |
Date: | 2008-02-29 17:32:15 |
Message-ID: | 47C8419F.2060909@ttc-cmc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Perhaps this is not the appropriate list, but is there a way to
determine this information
from the information_schema? The reason I ask is I can not seem to find
this information
there either. pg_dump does provide this information, though lacking the
ability to proper
identify multi-dimensional arrays, ex. char(30)[][] gives char(30)[].
danap.
> Currently the driver does not return this information, but we've
> listed it as an open feature request:
>
> http://pgfoundry.org/tracker/index.php?func=detail&aid=1010248&group_id=1000224&atid=857
>
> Kris Jurka
> Given a defined table as such:
>
> CREATE TABLE array_types (
>
> data_type_id serial NOT NULL,
> decimal_array decimal(16,2)[] DEFAULT NULL,
> numeric_array numeric(10,2)[] DEFAULT NULL,
> varchar_array varchar(30)[] DEFAULT NULL,
> char_array char(30)[][] DEFAULT NULL,
> PRIMARY KEY (data_type_id)
> );
>
> How do I obtain the precision, decimal places, or character
> sizing information from the database. Notice these are array
> types.
>
> danap.
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Migowski | 2008-02-29 17:36:53 | Re: Bug while retrieving money data type from db |
Previous Message | Kris Jurka | 2008-02-29 17:09:52 | Re: Bug while retrieving money data type from db |