Databases · Middle · Question 70 of 75

What are trade-offs of using a PostgreSQL `ENUM` type for a status column?

1Enums can't be used in WHERE
2Enums are slower than text in every case
✓Correct answer: Compact and type-safe, but removing or renaming values is awkward; a CHECK constraint or a lookup table is easier to change

Explanation

Adding enum values is easy; removing them requires recreating the type. A lookup table can also store extra data like labels or sort order.

Further reading

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.