Help Center > > User Guide> Working with RDS for PostgreSQL> PostgreSQL Enhanced Edition> Data Types

Data Types

Updated at: May 26, 2020 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel