CREATE TABLE t1 (id integer primary key generated always as identity);
How to set auto increment primary key in PostgreSQL?
I have a table in PostgreSQL with many columns, and I want to add an auto increment primary key.
I tried to create a column called id of type BIGSERIAL but pgadmin responded with an error: ERROR: