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 |