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

Re: Array Char/VarChar Size

From: Kris Jurka <books(at)ejurka(dot)com>
To: dmp <danap(at)ttc-cmc(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Array Char/VarChar Size
Date: 2008-02-29 17:53:57
Message-ID: Pine.BSO.4.64.0802291248520.30295@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Fri, 29 Feb 2008, dmp wrote:

> 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)[].

Multi-dimensional array information is not stored.  Every array type may 
be any number of dimensions.  The precision information is not available 
in the information_schema, but it is available in the system catalog 
tables.  See pg_attribute.atttypmod, but it does require some decoding.

Kris Jurka


In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2008-02-29 17:57:11
Subject: Re: Bug while retrieving money data type from db
Previous:From: Daniel MigowskiDate: 2008-02-29 17:36:53
Subject: Re: Bug while retrieving money data type from db

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