Oracle->PostgreSQL
Oracle -> PostgreSQL Community Edition
| 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
