Help Center/ Relational Database Service/ User Guide/ Working with RDS for PostgreSQL/ RDS for PostgreSQL Enhanced Edition/ Data Types
Updated on 2024-10-14 GMT+08:00
View PDF
Share

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
Parent Topic: RDS for PostgreSQL Enhanced Edition