Db2 for i Source Data Type | PostgreSQL Target Data Type |
|---|---|
bigint | bigint |
binary(size), 1 <= size <= 32766 | bytea |
char(size) for bit data, 1 <= size <= 32766 | bytea |
char(size), 1 <= size <= 32766 | character varying(size), 1 <= size <= 32766 |
date | date |
decfloat(precision), 16 <= p <= 34 | character varying(255) |
decimal(p,s), 1 <= p <= 63, 0 <= s <= 62 | numeric(p,s), 1 <= p <= 63, 0 <= s <= 62 |
float | double precision |
integer | integer |
long varbinary | bytea |
long varchar | text |
long varchar for bit data | bytea |
numeric(p,s), 1 <= p <= 63, 0 <= s <= 62 | numeric(p,s), 1 <= p <= 63, 0 <= s <= 62 |
real | real |
rowid | bytea |
smallint | smallint |
time | time(0) without time zone |
timestamp(precision), 0 <= p <= 6 | timestamp(precision) without time zone, 0 <= p <= 6 |
timestamp(precision), 7 <= p <= 12 | character varying(size), 27 <= size <= 32 |
varbinary(size), 1 <= size <= 32740 | bytea |
varchar(size) for bit data, 1 <= size <= 32740 | bytea |
varchar(size), 1 <= size <= 32740 | character varying(size), 1 <= size <= 32740 |