Postgres 14

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

CREATE TABLE Books 
(
    Id int generated always as identity,
    Title VARCHAR(50) NOT NULL,
    PRIMARY KEY(Id)
);
INSERT INTO Books (Id, Title)
VALUES
(3, 'The Catcher in the Rye');
ERROR:  cannot insert a non-DEFAULT value into column "id"
DETAIL:  Column "id" is an identity column defined as GENERATED ALWAYS.
HINT:  Use OVERRIDING SYSTEM VALUE to override.


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');
5 rows affected

select* from Books;


id
title


1
Nine Stories

2
The Great Gatsby

3
Tender id the Night

4
Pride and Prejudice

5
Professional ASP.NET 4.5 in C# and VB

id	title
1	Nine Stories
2	The Great Gatsby
3	Tender id the Night
4	Pride and Prejudice
5	Professional ASP.NET 4.5 in C# and VB