Practical ENUMs in PostgreSQL

Learn PostgreSQL ENUMs with practical challenges based on real-world scenarios. Learn how to create, modify, and effectively use ENUM types in your database design.

Each challenge comes with its own description, schema information, optional hints, and an automated evaluation system that validates your solution using a series of tests.

30 minutes Fundamentals

Challenges

1 User Roles as ENUM

2 Add new ENUM value

3 Remove an ENUM value

4 Beyond ENUMs

References

PostgreSQL ENUMs

boringSQL We need to talk about ENUMs

Ready to start?

Enter your email to receive a link to launch your 60-minute lab environment.

The lab is provided FREE. By launching it, you'll be subscribed to our SQL Labs newsletter (launch announcements only).

How it works: We'll verify you're human, send a confirmation email, and once you click the link, you'll instantly get access to a 60-minute PostgreSQL lab environment.

Required: You'll need a PostgreSQL client to connect. We recommend:

• macOS: Postico or psql (via Homebrew: brew install postgresql)

• Windows: pgAdmin, DBeaver, or psql (included with PostgreSQL)

• Linux: psql (apt install postgresql-client or yum install postgresql)

SQL Labs is part of boringSQL, brought to you by Clusterity s.r.o.