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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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