Scribd
Upload
14 views2 pages

Ora Postgres Data Type

The document provides a mapping of Oracle data types to their possible PostgreSQL equivalents. It includes various data types such as CHAR, VARCHAR, NUMBER, and TIMESTAMP, along with their corresponding PostgreSQL types. This mapping is useful for database migration or integration between Oracle and PostgreSQL systems.

Uploaded by

droppdrill
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

Ora Postgres Data Type

The document provides a mapping of Oracle data types to their possible PostgreSQL equivalents. It includes various data types such as CHAR, VARCHAR, NUMBER, and TIMESTAMP, along with their corresponding PostgreSQL types. This mapping is useful for database migration or integration between Oracle and PostgreSQL systems.

Uploaded by

droppdrill
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Oracle type Possible PostgreSQL types

CHAR char, varchar, text

NCHAR char, varchar, text

VARCHAR char, varchar, text

VARCHAR2 char, varchar, text, json

NVARCHAR2 char, varchar, text

CLOB char, varchar, text, json

LONG char, varchar, text

RAW uuid, bytea

BLOB bytea

BFILE bytea (read-only)

LONG RAW bytea

NUMBER numeric, float4, float8, char, varchar, text

NUMBER(n,m) with
numeric, float4, float8, int2, int4, int8, boolean, char, varchar, text
m<=0

FLOAT numeric, float4, float8, char, varchar, text

BINARY_FLOAT numeric, float4, float8, char, varchar, text

BINARY_DOUBLE numeric, float4, float8, char, varchar, text

DATE date, timestamp, timestamptz, char, varchar, text

TIMESTAMP date, timestamp, timestamptz, char, varchar, text


Oracle type Possible PostgreSQL types

TIMESTAMP WITH TIME


date, timestamp, timestamptz, char, varchar, text
ZONE

TIMESTAMP WITH LOCAL


date, timestamp, timestamptz, char, varchar, text
TIME ZONE

INTERVAL YEAR TO
interval, char, varchar, text
MONTH

INTERVAL DAY TO
interval, char, varchar, text
SECOND

XMLTYPE xml

MDSYS.SDO_GEOMETRY geometry

You might also like