PostgreSQL identity column

Topic | v2 | updated by jjones |

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.


subtopic of PostgreSQL

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

Edit details Edit relations Attach new author Attach new topic Attach new resource

has official PostgreSQL: Documentation: 10: CREATE TABLE

CREATE TABLE — define a new table

treated in PostgreSQL Identity Column

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

treated in PostgreSQL 10 identity columns explained

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