Array Char/VarChar Size

From: dmp <danap(at)ttc-cmc(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Array Char/VarChar Size
Date: 2008-02-27 07:35:38
Message-ID: 47C512CA.9010808@ttc-cmc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Daniel Migowski 2008-02-27 07:57:13 Re: Fastest way to check aliveness of connection
Previous Message Oliver Jowett 2008-02-26 22:20:24 Re: Fastest way to check aliveness of connection