PostgreSQL identity column


Topic | v2 | updated by jjones |
Description

PostgreSQL version 10 introduced a new feature called GENERATED AS IDENTITY constraint that allows you to automatically assign a unique value to a column. The GENERATED AS IDENTITY constraint is the SQL standard-conforming variant of the PostgreSQL’s SERIAL column.


Relations

a subtopic of PostgreSQL

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (...


Edit topic New topic

Resources

No beginner resources matching your criteria have been registered, yet.

No intermediate resources matching your criteria have been registered, yet.

No advanced resources matching your criteria have been registered, yet.

is treated in PostgreSQL 10 identity columns explained

For PostgreSQL 10, I have worked on a feature called “identity columns”. Depesz already wrote a blog...

is treated in PostgreSQL Identity Column

This tutorial shows you how to use the GENERATED AS IDENTITY constraint to create the PostgreSQL iden...

official PostgreSQL: Documentation: 10: CREATE TABLE

CREATE TABLE — define a new table