Skip to content

Glossary: PostgreSQL for Developers

primary key

Also written: PRIMARY KEY

The column (or columns) that uniquely identifies each row in a table, which other tables point at with foreign keys. It is commonly a generated surrogate key, such as an identity number, rather than real-world data.

Where the book teaches it

Related terms

surrogate keyforeign key constraintidentity column