Oracle->PostgreSQL

**Table 1** Data type mapping
Data Type (Oracle)	Data Type (PostgreSQL Community Edition)	Whether to Support Mapping
CHAR	CHAR	Yes
VARCHAR	VARCHAR	Yes
VARCHAR2	VARCHAR	Yes
NCHAR	NCHAR	Yes
NVARCHAR2	VARCHAR	Yes
NUMBER	NUMBER	Yes
BINARY_FLOAT	REAL	Yes
BINARY_DOUBLE	DOUBLE	Yes
FLOAT	FLOAT	Yes
DATE	TIMESTAMP	Yes
TIMESTAMP	TIMESTAMP	Yes. If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database.
TIMESTAMP WITH TIME ZONE	TIMESTAMPTZ	Yes. If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database.
TIMESTAMP WITH LOCAL TIME ZONE	TIMESTAMPTZ	Yes. If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database.
INTERVAL	INTERVAL	Yes
BLOB	BYTEA	Yes
CLOB	CLOB	Yes
NCLOB	TEXT	Yes
LONG	TEXT	Yes
LONG_RAW	BYTEA	Yes
RAW (non-primary key and non-unique key column)	BYTEA	Yes
RAW (primary key and unique key column)	VARCHAR	Yes
ROWID	CHARACTER(18)	Yes
UROWID	-	No
XMLTYPE	TEXT	Yes
BFILE	-	No
SDO_GEOMETRY	-	No