Schemint

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

Convert SQL Server (T-SQL) to PostgreSQL online

Paste T-SQL, get PostgreSQL. Nothing you paste is stored.

Paste SQL Server T-SQL (a CREATE TABLE or a query) and get the PostgreSQL equivalent: IDENTITY(1,1) becomes a generated identity column, NVARCHAR becomes VARCHAR (PostgreSQL is Unicode throughout), DATETIME2 becomes TIMESTAMP and GETDATE() becomes CURRENT_TIMESTAMP.

Converted on the server, discarded after the response.

Try it on your own schema

Example

SQL Server in:

CREATE TABLE product (
    id BIGINT IDENTITY(1, 1) PRIMARY KEY,
    sku NVARCHAR(40) NOT NULL UNIQUE,
    name NVARCHAR(200) NOT NULL,
    price DECIMAL(12, 2) NOT NULL,
    in_stock BIT NOT NULL DEFAULT 1,
    created_at DATETIME2 NOT NULL DEFAULT GETDATE()
);

Generated:

postgres.sql

CREATE TABLE product (
  id BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1) PRIMARY KEY,
  sku VARCHAR(40) NOT NULL UNIQUE,
  name VARCHAR(200) NOT NULL,
  price DECIMAL(12, 2) NOT NULL,
  in_stock BIT NOT NULL DEFAULT 1,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

Related