Skip to content
DCodeMan
  • Home
  • Resources
    • Documentation
      • Oracle 19c SQL
      • Oracle 19c PL/SQL
      • Oracle to PostgreSQL Migration
      • RDBMS
    • Q & A
    • Courses
  • Blogs
  • Login
Menu Close
  • Home
  • Resources
    • Documentation
      • Oracle 19c SQL
      • Oracle 19c PL/SQL
      • Oracle to PostgreSQL Migration
      • RDBMS
    • Q & A
    • Courses
  • Blogs
  • Login

CREATE TABLE

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

Oracle to PostgreSQL Migration

  • Database Migration Basics
    • Introduction to Database Migration
    • Database Migration Outline
    • SQL Statements
    • SQL Clauses
    • Data types
    • Most Common SQL Differences
    • Type Casting
  • Migrate Tables
    • Migrating Oracle SCOTT user tables
  • Built-in Functions
    • Functions Overview
    • Similar Functions
    • Dissimilar Functions
    • Inconsistent Functions
  • NULL Handling
    • Facts with NULL
    • Converting pipe “||” operator
    • NULL in Unique Constraints
  • SQL Commands
    • CREATE TABLE
    • ALTER TABLE
  • SQL – Oracle vs PG
    • Migrate Joins
    • Migrate Subqueries
    • Migrate Hierarchical Queries
  • Database Objects
  • Transaction Handling
    • Transaction Overview
    • Transaction with DDL
  • PLSQL vs plpgsql
    • Anonymous Block
    • Migrating DBMS_OUTPUT.PUT_LINE
    • Migrate User defined types
  • Migrating Oracle Collections
    • Convert Associative Array
    • Convert PL/SQL table
    • Convert Varray
  • Miscellaneous Migration Queries
    • Constraints disable and drop
  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.

Still stuck? How can we help?
Updated on February 21, 2021

Doc navigation

ALTER TABLE →
Was this article helpful to you? Yes No

How can we help?

DCODEMAN

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms of use

Resource Hub

  • Q & A
  • Documentation
  • Blogs
  • Courses

What’s Fascinating!

  • Donate
  • Oracle SQL Q&A
  • Oracle PL/SQL Q&A
  • Interesting Facts

Share

Copyright © 2020 DCODEMAN, All rights reserved.

Login

Continue with Google

Forgot Password?

Create a new account

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.