PRIMARY KEY and identity.

PRIMARY KEY identifies a row. In PostgreSQL, GENERATED BY DEFAULT AS IDENTITY supplies ids. After creating the table, insert one row with title only (no id).

Small example:

CREATE TABLE books ( id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, title TEXT NOT NULL ); INSERT INTO books (title) VALUES ('Demo');