Introduction
Defining columns with UNIQUE
Adding and removing UNIQUE constraints
Instruction
As you have seen, the values in the name column are indeed unique. After all, no two games should share the same name, right?
Exercise
Let's add another board game to our board_game table. It's called Carcassonne, the genre is medieval, the minimum number of players is 2, the minimum age is 10, and the price is listed at 32.99. Don't worry about the id column – it's defined as GENERATED ALWAYS AS IDENTITY and IDENTITY will take care of the numbering.
Stuck? Here's a hint!
Syntax reminder:
INSERT INTO board_game (...) VALUES (...);
