CREATE TABLE "Data_Types" ( "ID" bigserial NOT NULL PRIMARY KEY, "smallint" smallint default 1, "integer" integer NOT NULL default 1, "bigint" bigint default NULL, "numeric" numeric(9, 2) default 0.11, "decimal" decimal(12) default NULL, "real" real default NULL, "float" float(20) default 0.23, "money" money default '0.32', "money_default_NULL" money default NULL, "character_varying" character varying(10) default 'abc', "varchar" varchar(12) default NULL, "char" char(20) default NULL, "text" text default 'tx', "bytea" bytea default 'aif\'', "timestamp" timestamp default '1999-01-01 01:00:00', "timestamp_with_time_zone" timestamp with time zone default '1999-01-01 01:00:00+01', "interval" interval default '1 01:00:00', "date" date default '1999-01-01', "time" time default '01:00:00', "time_with_time_zone" time with time zone default '01:00:00+12', "boolean" boolean default true, "boolean2" boolean default true, "point" point default '(0,1)', "lseg" lseg default '(0,0),(3,3)', "box" box default '(1,0),(3,3)', "path" path default '((0,0),(1,1))', "polygon" polygon default '((0,0),(1,1))', "circle" circle default '((0,0), 1)', "cidr" cidr default '192.168.1.0', "inet" inet default '192.168.0.0', "macaddr" macaddr default '08002b:010203', "bit" bit(3) default '011', "bit_varying" bit varying(5) default '10001' );