SQL auto increment pgadmin 4

Question

I am trying to make a simple database with an number generator but why do I get the error below?

ERROR: syntax error at or near "AUTO_INCREMENT"
LINE 2: IDNumber int NOT NULL AUTO_INCREMENT,

Code:

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

Answer 1

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

Answer 2

For Postgres you have to use SERIAL

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

Answer 3

IN pgadmin-2. step 01: create seq:

and set info:

step 02: go to ID in table and set constraints