Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE hr_leave (id int PRIMARY KEY, txt text);
INSERT INTO hr_leave VALUES (1,'foo1');

CREATE TABLE

INSERT 0 1

CREATE SEQUENCE myseq START WITH 1 INCREMENT BY 2;
SELECT setval('myseq', (SELECT MAX(id) FROM hr_leave));

ALTER TABLE hr_leave ALTER COLUMN id SET DEFAULT nextval('myseq');

CREATE SEQUENCE

setval

1

SELECT 1

ALTER TABLE

INSERT INTO hr_leave (txt) VALUES ('foo2'),('foo3');
SELECT * FROM hr_leave;

INSERT 0 2

id
txt

1
foo1

3
foo2

5
foo3

SELECT 3