| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kris Jurka | 2008-02-29 17:57:11 | Re: Bug while retrieving money data type from db |
| Previous Message | Daniel Migowski | 2008-02-29 17:36:53 | Re: Bug while retrieving money data type from db |