Primary key

The primary key uniquely identifies each row of a table: its values are unique and non-null. It can be made of several columns. It is often an auto-incremented technical identifier, and an index is created automatically to enforce it.

Example

id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY

Related concepts

The whole glossary