Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyBasic SELECT

Create table with IF NOT EXISTS

SQL

CREATE TABLE IF NOT EXISTS regions (
  region_id INT PRIMARY KEY,
  region_name VARCHAR(50) NOT NULL
);

Tested against PostgreSQL 16

Note

“Prevents errors if the table already exists. Great for idempotent migration scripts.