CHAR(n) |
CHAR(n) COLLATE RTRIM |
VARCHAR(n[,m]) |
VARCHAR(n) COLLATE RTRIM |
LVARCHAR(n) |
VARCHAR(n) COLLATE RTRIM |
NCHAR(n) |
NCHAR(n) |
NVARCHAR(n) |
NVARCHAR(n) |
BOOLEAN |
BOOLEAN |
SMALLINT |
SMALLINT |
INT / INTEGER |
INTEGER |
BIGINT |
BIGINT |
INT8 |
BIGINT |
SERIAL[(start)] |
INTEGER (see note) |
BIGSERIAL[(start)] |
N/A (see note) |
INT8[(start)] |
N/A (see note) |
DOUBLE PRECISION / FLOAT[(n)] |
FLOAT |
REAL / SMALLFLOAT |
SMALLFLOAT |
NUMERIC / DEC / DECIMAL(p,s) |
DECIMAL(p,s) |
NUMERIC / DEC / DECIMAL(p) |
DECIMAL(p,s) |
NUMERIC / DEC / DECIMAL |
DECIMAL |
MONEY(p,s) |
DECIMAL(p,s) |
MONEY(p) |
DECIMAL(p,2) |
MONEY |
DECIMAL(16,2) |
TEXT |
TEXT |
BYTE |
BLOB |
DATE |
DATE |
DATETIME HOUR TO SECOND |
TIME |
DATETIME q1 TO q2 (different from
above) |
TIMESTAMP |
INTERVAL q1 TO q2 |
CHAR(50) |