Schemint

paste PostgreSQL or JSON, get your schema reviewed like a senior would

Convert Oracle to PostgreSQL online

Paste Oracle SQL, get PostgreSQL. Nothing you paste is stored.

Paste Oracle SQL (a CREATE TABLE or a query) and get the PostgreSQL equivalent: NUMBER(p, s) becomes DECIMAL, VARCHAR2 becomes VARCHAR, SYSTIMESTAMP becomes CURRENT_TIMESTAMP, and identity columns carry over.

Converted on the server, discarded after the response.

Try it on your own schema

Example

Oracle in:

CREATE TABLE product (
    id NUMBER(19) GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    sku VARCHAR2(40) NOT NULL UNIQUE,
    name VARCHAR2(200) NOT NULL,
    price NUMBER(12, 2) NOT NULL,
    in_stock NUMBER(1) DEFAULT 1 NOT NULL,
    created_at TIMESTAMP DEFAULT SYSTIMESTAMP NOT NULL
);

Generated:

postgres.sql

CREATE TABLE product (
  id DECIMAL(19) GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
  sku VARCHAR(40) NOT NULL UNIQUE,
  name VARCHAR(200) NOT NULL,
  price DECIMAL(12, 2) NOT NULL,
  in_stock DECIMAL(1) DEFAULT 1 NOT NULL,
  created_at TIMESTAMP DEFAULT SYSTIMESTAMP() NOT NULL
);

Related