PostgreSQL and Other Databases - SQL Differences and Conversion Reference

Summary information on SQL differences between PostgreSQL and other databases.

a feature is supported and no syntax conversion is required, but subtle functional differences still may exist (browse for the details to see them).

a feature is supported but there are differences in clauses, range, options etc. so syntax conversion may be required in some cases.

Run Online Conversion to get a detailed report what needs to be converted in particular SQL statements and scripts.

Data Types

Differences in data types:

PostgreSQL	Oracle	SQL Server	MySQL
INT, INTEGER	NUMBER(10)
SERIAL		IDENTITY	AUTO_INCREMENT
TEXT	CLOB	VARCHAR(max)

Queries - SELECT Statement

Differences in SQL SELECT syntax:

PostgreSQL	Oracle	SQL Server	MySQL
LIMIT
OFFSET

Statements

Differences in SQL statements and clauses:

PostgreSQL	Oracle	SQL Server	MySQL
CREATE TEMPORARY TABLE