EnterpriseDB
  • Home
  • Category
    Installation & Getting Started Quick Start Reference User Guides
  • Product
    EDB Backup and Recovery Tool EDB JDBC Connector EDB .NET Connector EDB OCL Connector EDB ODBC Connector EDB*Plus EDB Postgres Advanced Server EDB Postgres Ark Platform EDB Postgres Cloud Database Service EDB Postgres Enterprise Manager EDB Postgres Failover Manager EDB Postgres Hadoop Foreign Data Wrapper EDB Postgres Language Pack EDB Postgres Migration Portal EDB Postgres Migration Toolkit EDB Postgres MongoDB Foreign Data Wrapper EDB Postgres MySQL Foreign Data Wrapper EDB Postgres PgBouncer EDB Postgres Pgpool-II EDB Postgres PostGIS EDB Postgres Replication Server EDB Postgres Slony Replication PostgreSQL pgAdmin 4

EDB Postgres Advanced Server → 9.6 → Reference → Database Compatibility for Oracle® Developers Reference Guide
Other versions of this page: 12 · 11 · 10 · 9.6

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

Table of Contents Previous Next


2 The SQL Language : 2.2 Data Types

2.2 Data Types
The following table shows the built-in general-purpose data types.
Table 3‑2‑1 Data Types
Name
Alias
Description
BLOB
LONG RAW, RAW(n), BYTEA
Binary data
BOOLEAN
 
Logical Boolean (true/false)
CHAR [ (n) ]
CHARACTER [ (n) ]
Fixed-length character string of n characters
CLOB
LONG, LONG VARCHAR
Long character string
DATE
TIMESTAMP(0)
Date and time to the second
DOUBLE PRECISION
FLOAT,
FLOAT(25) – FLOAT(53)
Double precision floating-point number
INTEGER
INT, BINARY_INTEGER, PLS_INTEGER
Signed four-byte integer
NUMBER
DEC, DECIMAL, NUMERIC
Exact numeric with optional decimal places
NUMBER(p [, s ])
DEC(p [, s ]),
DECIMAL(p [, s ]),
NUMERIC(p [, s ])
Exact numeric of maximum precision, p, and optional scale, s
REAL
FLOAT(1) – FLOAT(24)
Single precision floating-point number
TIMESTAMP [ (p) ]
 
Date and time with optional, fractional second precision, p
TIMESTAMP [ (p) ] WITH TIME ZONE
 
Date and time with optional, fractional second precision, p, and with time zone
VARCHAR2(n)
CHAR VARYING(n), CHARACTER VARYING(n), VARCHAR(n)
Variable-length character string with a maximum length of n characters
XMLTYPE
 
XML data

2 The SQL Language : 2.2 Data Types

Table of Contents Previous Next
© 2021 EnterpriseDB Corporation. All rights reserved. | Privacy Policy | Terms of Use | Trademarks