Updated on 2023-07-06 GMT+08:00

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