1. Home
  2. Docs
  3. Oracle to PostgreSQL Migration
  4. SQL Commands
  5. CREATE TABLE

CREATE TABLE

CREATE TABLE syntax is mostly compatible between Oracle and PostgreSQL with following changes.

  • Modify column data types from Oracle to PostgreSQL types.
  • PostgreSQL lacks global temporary tables. Use temporary tables instead.

Was this article helpful to you? Yes No

How can we help?