Updated on 2024-03-28 GMT+08:00

Oracle->PostgreSQL

Oracle -> PostgreSQL Community Edition

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

TIMESTAMP WITH TIME ZONE

TIMESTAMPTZ

Yes

TIMESTAMP WITH LOCAL TIME ZONE

TIMESTAMPTZ

Yes

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

-

No

BFILE

-

No

SDO_GEOMETRY

-

No