Skip to content

Glossary: PostgreSQL for Developers

identity column

Also written: GENERATED ALWAYS AS IDENTITY, serial

A column whose numbers (1, 2, 3...) Postgres generates for you. GENERATED ALWAYS means only Postgres may set it. The older serial type does the same job.

Where the book teaches it

Related terms

surrogate keyRETURNING