SQL reference v16

This SQL reference information applies to organizations migrating their Oracle applications to use EDB Postgres Advanced Server.

A subset of the EDB Postgres Advanced Server SQL language is compatible with Oracle databases. These SQL syntaxes, data types, and functions work in both EDB Postgres Advanced Server and Oracle.


The EDB Postgres Advanced Server also includes syntax and commands for extended functionality (functionality that doesn't provide database compatibility for Oracle or support Oracle-styled applications) that aren't included here.

SQL syntax

Provides basic information about the general syntax

Data types

Provides descriptive information about specific data types

Functions and operators

Provides descriptions of functions and operators for the built-in data types