SQL auto increment pgadmin 4

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)
);