This is an old revision of the document!
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.
Differences in data types:
PostgreSQL | Oracle | SQL Server | MySQL |
INT, INTEGER | NUMBER(10) | ||
SERIAL | Sequence and trigger | IDENTITY | AUTO_INCREMENT |
TEXT | CLOB | VARCHAR(max) |
Differences in SQL statements and clauses:
PostgreSQL | Oracle | SQL Server | MySQL |
CREATE TEMPORARY TABLE |