Postgres 14

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

CREATE TABLE Books 
(
    Id serial,
    Title VARCHAR(50) NOT NULL,
    PRIMARY KEY(Id)
);

CREATE TABLE


INSERT INTO Books (Id, Title)
VALUES
(3, 'The Catcher in the Rye');

INSERT 0 1


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



SELECT 1