Help Center> Relational Database Service> User Guide> Working with RDS for PostgreSQL> RDS for PostgreSQL Enhanced Edition> Data Types
Updated on 2022-09-02 GMT+08:00
View PDF

Data Types

This section describes the data types added to RDS for 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

NVARCHAR

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