Sequences

CREATE SEQUENCE IF NOT EXISTS seq1
INCREMENT 16
MINVALUE 0
MAXVALUE 128
START WITH 0;

-- Options
SELECT setval('seq1', 16, false);
SELECT currval('seq1');
SELECT nextval('seq1');

ALTER SEQUENCE seq1 RENAME TO seq2;
ALTER SEQUENCE seq2 RESTART WITH 16;

DROP SEQUENCE seq2;

DROP TABLE book;

CREATE TABLE book
(
    book_id int GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) NOT NULL,
    title text NOT NULL,
    isbn varchar(32),
    publisher_id int NOT NULL,
    
    CONSTRAINT PK_book_book_id PRIMARY KEY(book_id)
)

INSERT INTO book (title, isbn, publisher_id)
VALUES ('title1', 'isbn1', 1);

SELECT * FROM book;