Oracle Source Data Type | PostgreSQL Target Data Type |
|---|---|
binary_double | double precision |
binary_float | real |
blob | bytea |
char(s byte), 1 <= s <= 2000 | character varying(size), 1 <= size <= 500 |
char(s char), 1 <= s <= 2000 | character varying(size), 1 <= size <= 2000 |
clob | text |
date | timestamp(precision) without time zone, 0 <= p <= null |
float(precision), 1 <= p <= 126 | character varying(255) |
integer | character varying(255) |
long raw | bytea |
long(2147483648 byte) | text |
nchar(s char), 1 <= s <= 2000 | character varying(size), 1 <= s <= 2000 |
nclob | text |
number | character varying(255) |
number(*,s), -84 <= s <= 127 | character varying(255) |
number(p,s), 1 <= p <= 38, -84 <= s <= 127 | numeric(p,s), 1 <= p <= 127, 0 <= s <= 127 |
nvarchar2(s char), 1 <= s <= 4000 | character varying(size), 1 <= s <= 4000 |
raw(size), 1 <= s <= 2000 | bytea |
rowid | character(18) |
timestamp(precision) with time zone, 0 <= p <= 6 | timestamp(precision) with time zone, 0 <= p <= 6 |
timestamp(precision) with time zone, 7 <= p <= 9 | character varying(size), 67 <= size <= 69 |
timestamp(precision), 1 <= p <= 6 | timestamp(precision) without time zone, 1 <= p <= 6 |
timestamp(precision), 7 <= p <= 9 | character varying(size), 27 <= size <= 29 |
varchar2(s byte), 1 <= s <= 4000 | character varying(size), 1 <= size <= 1000 |
varchar2(s char), 1 <= s <= 4000 | character varying(size), 1 <= size <= 4000 |
xml | character varying |