PostgreSQL identity column

Topic | v2 | updated by jjones |
Edit
bookmark
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.

Source postgresqltutorial.com/postgresql-identity-column
Relations

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
Resources

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...

treated in Waiting for PostgreSQL 10 – Identity columns – select * from depesz;