Better to use SERIAL PRIMARY KEY or GENERATED ALWAYS AS IDENTITY for primary key in PostgreSQL
Not sure which option is latest best practice? I read on on this tutorial that: https://www.postgresqltutorial.com/postgresql-identity-column/ PostgreSQL version 10 introduced a new constraint GENERATED AS IDENTITY that allows you to automatically assign a unique number to a column. The GENERATED AS IDENTITY constraint is the SQL standard-conforming variant
postgresql