Add an auto increment primary key in PostgreSQL

PostgreSQL

 

A well-known open-source database, developed by PostgreSQL Global Development Group. Skyvia requires the server to be available from Internet. Skyvia supports PostgreSQL, EnterpriseDB, Pervasive Postgres SQL servers, Heroku Postgres.

How to set auto increment primary key in PostgreSQL

Query Text

ALTER TABLE your_table 
    ADD COLUMN key_column BIGSERIAL PRIMARY KEY;
  

Open Query