1 -- $Header: /home/faga/work/sqlfairy_svn/sqlfairy-cvsbackup/sqlfairy/t/data/pgsql/entire_syntax.sql,v 1.1 2003-08-17 00:42:57 rossta Exp $
5 -- smallint int2 signed two-byte integer
6 -- integer int, int4 signed four-byte integer
7 -- bigint int8 signed eight-byte integer
8 -- serial serial4 autoincrementing four-byte integer
9 -- bigserial serial8 autoincrementing eight-byte integer
11 -- real float4 single precision floating-point number
12 -- double precision float8 double precision floating-point number
14 -- numeric [ (p, s) ] decimal [ (p, s) ] exact numeric with selectable precision
16 -- character(n) char(n) fixed-length character string
17 -- character varying(n) varchar(n) variable-length character string
19 -- date calendar date (year, month, day)
21 -- time [ (p) ] [ without time zone ] time of day
22 -- time [ (p) ] with time zone timetz time of day, including time zone
24 -- timestamp [ (p) ] without time zone timestamp date and time
25 -- timestamp [ (p) ] [ with time zone ] timestamptz date and time, including time zone
29 -- text variable-length character string
33 -- bit fixed-length bit string
34 -- bit varying(n) varbit(n) variable-length bit string
35 -- boolean bool logical Boolean (true/false)
36 -- box rectangular box in 2D plane
37 -- cidr IP network address
38 -- circle circle in 2D plane
39 -- inet IP host address
40 -- interval(p) general-use time span
41 -- line infinite line in 2D plane (not implemented)
42 -- lseg line segment in 2D plane
43 -- macaddr MAC address
44 -- money currency amount
45 -- path open and closed geometric path in 2D plane
46 -- point geometric point in 2D plane
47 -- polygon closed geometric path in 2D plane
49 -- Compatibility: The following types (or spellings thereof) are specified by SQL:
50 -- bit, bit varying, boolean, char, character, character varying, varchar, date,
51 -- double precision, integer, interval, numeric, decimal, real, smallint, time,
52 -- timestamp (both with or without time zone).
79 c04 CHARACTER VARYING(10),