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`