SQL auto increment pgadmin 4

sql

The subject of the question mentions pgAdmin 4, so here's how to do it there.

First, add a column to your table, then click the little edit icon:

Then go to Constraints and select the Identity type:

This generates SQL similar to this:

CREATE TABLE public.my_table_name(    id integer NOT NULL GENERATED ALWAYS AS IDENTITY,    PRIMARY KEY (id));

sql

For Postgres you have to use SERIAL

CREATE TABLE Finance(    IDNumber SERIAL PRIMARY KEY,    FinName varchar(50) NOT NULL);

sql

IN pgadmin-2.step 01:create seq:

and set info:

step 02: go to ID in table and set constraints

CodeHunter