Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ Oracle->PostgreSQL

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

View PDF

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

Parent topic: Mapping Data Types

Previous topic: Oracle->GaussDB(DWS)

Next topic: GaussDB(for MySQL)->Oracle

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.