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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Array Char/VarChar Size



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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group