Array Char/VarChar Size - Mailing list pgsql-jdbc

From dmp
Subject Array Char/VarChar Size
Date
Msg-id 47C512CA.9010808@ttc-cmc.net
Whole thread Raw
Responses Re: Array Char/VarChar Size  (Kris Jurka <books@ejurka.com>)
Re: Array Char/VarChar Size  (dmp <danap@ttc-cmc.net>)
List 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.

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Fastest way to check aliveness of connection
Next
From: Daniel Migowski
Date:
Subject: Re: Fastest way to check aliveness of connection