PostgreSQL Basic Guide

Primary Keys

Autoincrement numeric id

CREATE TABLE users (
  id SERIAL PRIMARY KEY
);

Autogenerated UUID id

CREATE TABLE products (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY
);

ENUM type

Create an ENUM type

CREATE TYPE order_status AS ENUM ('open', 'pending', 'closed', 'canceled');

Use created type

CREATE TABLE order (
  id SERIAL PRIMARY KEY,
  status order_status
);