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 |
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 | TEXT | Yes |
BFILE | - | No |
SDO_GEOMETRY | - | No |
Parent topic: Mapping Data Types
- Oracle -> PostgreSQL Community Edition