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 | IDENTITY | AUTO_INCREMENT | |
TEXT | CLOB | VARCHAR(max) |
Differences in SQL statements and clauses:
PostgreSQL | Oracle | SQL Server | MySQL |
CREATE TEMPORARY TABLE |