2 The SQL Language

Other Resources

Download Postgres
Free Postgres Training
Webinar: Exploring 10 Postgres Tips and Tricks

Postgres as a Service

Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.

Try it Now Free

2 The SQL Language

2 The SQL Language

The following sections describe the subset of the Advanced Server SQL language compatible with Oracle databases. The following SQL syntax, commands, data types, and functions work in both EDB Postgres Advanced Server and Oracle.

The Advanced Server documentation set includes syntax and commands for extended functionality (functionality that does not provide database compatibility for Oracle or support Oracle-styled applications) that is not included in this guide.

This section is organized into the following sections:

•

General discussion of Advanced Server SQL syntax and language elements

•

Data types

•

Summary of SQL commands

•

Built-in functions

2 The SQL Language