By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE category(id INTEGER PRIMARY KEY, category_name TEXT);
✓
CREATE TABLE t(
id INTEGER PRIMARY KEY,
category_id INTEGER,
CONSTRAINT "model" FOREIGN KEY("category_id") REFERENCES "category"("id")
ON DELETE CASCADE
DEFERRABLE INITIALLY DEFERRED
);
✓