PostgreSQL identity column

Topic history | v2 (current) | updated by jjones

Details

PostgreSQL identity column

| updated by jjones | Edit topic "PostgreSQL identity column"
Title
PostgreSQL identity column
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.
Link
https://www.postgresqltutorial.com/postgresql-identity-column/

PostgreSQL identity column

| created by jjones | Add topic "PostgreSQL"
Title
PostgreSQL identity column
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.
Link
https://www.postgresqltutorial.com/postgresql-identity-column/

resources

has official PostgreSQL: Documentation: 10: CREATE TABLE
v1 | attached by jjones | Add topic "PostgreSQL"
treated in PostgreSQL Identity Column
v1 | attached by jjones | Add topic "PostgreSQL"
treated in PostgreSQL 10 identity columns explained
v1 | attached by jjones | Add topic "PostgreSQL"
treated in Waiting for PostgreSQL 10 – Identity columns – select * from depesz;
v1 | attached by jjones | Add topic "PostgreSQL"

authors

This topic has no history of related authors.

topics

subtopic of PostgreSQL
| updated by jjones | Edit topic "PostgreSQL identity column"
is
v1 | attached by jjones | Add topic "PostgreSQL"