CHAR(n) |
CHAR(n) or NCHAR(n) if UTF-8 |
VARCHAR(n[,m]) |
VARCHAR(n) or NVARCHAR if UTF-8 |
NCHAR(n) |
NCHAR(n) (UTF-8) |
NVARCHAR(n[,m]) |
NVARCHAR(n) (UTF-8) |
BOOLEAN |
BOOLEAN |
SMALLINT |
SMALLINT |
INT / INTEGER |
INTEGER |
BIGINT |
BIGINT |
INT8 |
BIGINT |
SERIAL[(start)] |
N/A (see note) |
BIGSERIAL[(start)] |
N/A (see 1 note) |
SERIAL8[(start)] |
N/A (see note) |
DOUBLE PRECISION / FLOAT[(n)] |
DOUBLE |
REAL / SMALLFLOAT |
REAL |
NUMERIC / DEC / DECIMAL(p,s) |
DECIMAL(p,s) |
NUMERIC / DEC / DECIMAL(p) |
DECIMAL(p*2,p) |
NUMERIC / DEC / DECIMAL |
DECIMAL(32,16) |
MONEY(p,s) |
DECIMAL(p,s) |
MONEY(p) |
DECIMAL(p,2) |
MONEY |
DECIMAL(16,2) |
TEXT |
N/A |
BYTE |
N/A |
DATE |
DATE |
DATETIME HOUR TO SECOND |
TIME |
DATETIME YEAR TO FRACTION(p) |
TIMESTAMP |
INTERVAL YEAR[(p)] TO MONTH |
CHAR(50) |
INTERVAL YEAR[(p)] TO YEAR |
CHAR(50) |
INTERVAL MONTH[(p)] TO MONTH |
INTERVAL |
INTERVAL DAY[(p)] TO FRACTION(n) |
INTERVAL |
INTERVAL DAY[(p)] TO SECOND |
INTERVAL |
INTERVAL DAY[(p)] TO MINUTE |
INTERVAL |
INTERVAL DAY[(p)] TO HOUR |
INTERVAL |
INTERVAL DAY[(p)] TO DAY |
INTERVAL |
INTERVAL HOUR[(p)] TO FRACTION(n) |
INTERVAL |
INTERVAL HOUR[(p)] TO SECOND |
INTERVAL |
INTERVAL HOUR[(p)] TO MINUTE |
INTERVAL |
INTERVAL HOUR[(p)] TO HOUR |
INTERVAL |
INTERVAL MINUTE[(p)] TO FRACTION(n) |
INTERVAL |
INTERVAL MINUTE[(p)] TO SECOND |
INTERVAL |
INTERVAL MINUTE[(p)] TO MINUTE |
INTERVAL |
INTERVAL SECOND[(p)] TO FRACTION(n) |
INTERVAL |
INTERVAL SECOND[(p)] TO SECOND |
INTERVAL |
INTERVAL FRACTION[(p)] TO FRACTION(n) |
INTERVAL |