PostgreSQL to Oracle mapping

AutoSync maps PostgreSQL object types to the following Oracle column types:

PostgreSQL object type Oracle column type
serial number(6)
bigserial number(11)
int2 number(6)
int4 number(11)
int8 number(20)
numeric number
numeric_without_prec_scale varchar2
float4 binary_float
float8 binary_double
money binary_double
bytea blob
varchar varchar2
bpchar varchar2
text varchar2
cidr varchar2
inet varchar2
macaddr varchar2
macaddr8 varchar2
bit varchar2
uuid varchar2
xml varchar2
json nclob
jsonb nclob
tsvector varchar2
tsquery varchar2
timestamp timestamp
timestamptz timestamp
date date
time varchar2
timetz varchar2
interval varchar2
point varchar2
line varchar2
lseg varchar2
box varchar2
path varchar2
polygon varchar2
circle varchar2
geometry nclob
array varchar2
composite varchar2
range varchar2
oid number(11)
pg_lsn varchar2
bool number(1)
char char
name varchar2
sl_timestamp timestamp