Postgres 14

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

CREATE TABLE Books 
(
    Id int generated by default as identity,
    Title VARCHAR(50) NOT NULL,
    PRIMARY KEY(Id)
);
INSERT INTO Books (Id, Title)
VALUES
(3, 'The Catcher in the Rye');
1 rows affected

INSERT INTO Books (Title)
VALUES
('Nine Stories'),
('The Great Gatsby'),
('Tender id the Night'),
('Pride and Prejudice'),
('Professional ASP.NET 4.5 in C# and VB');
ERROR:  duplicate key value violates unique constraint "books_pkey"
DETAIL:  Key (id)=(3) already exists.


select* from Books;


id
title


3
The Catcher in the Rye