Help Center/ Relational Database Service/ User Guide (ME-Abu Dhabi Region) / Working with RDS for PostgreSQL/ PostgreSQL Enhanced Edition/ Data Types
Updated on 2023-07-06 GMT+08:00
View PDF
Share

Data Types

This section describes the data types added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open source edition.

Table 1 Data types

Name

Data Type

Variable-length character type

VARCHAR2 and NVARCHAR2

Decimal floating point type

DECIMAL

Double precision binary floating point type

BINARY_DOUBLE

Binary data type

RAW

Binary large object type

BLOB

Character large object type

CLOB

National character large object

NCLOB

Number type

NUMBER

Variable-length character type

NVARACHAR

Unicode character data type

NCHAR

32-bit floating point data type

BINARY_FLOAT

Long integer

LONG

XML data type

XMLType

Timestamp with local time zone

TIMESTAMP WITH LOCAL TIME ZONE

PL/SQL integer numeric data

BINARY_INTEGER

PL/SQL integer numeric data

PLS_INTEGER