Re: Array Char/VarChar Size

[dmp <danap(at)ttc-cmc(dot)net>]

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.