[Solved] In PostgreSQL, what is the primary advantage of using an ENUM type over a simple TEXT column? — Ans: It restricts the column to a predefined set of values, improving data integrity. | PostgreSQL

PostgreSQL - Advanced Features

In PostgreSQL, what is the primary advantage of using an ENUM type over a simple TEXT column?

AIt allows storing multiple values in a single column.

BIt restricts the column to a predefined set of values, improving data integrity.

CIt automatically indexes the column for faster queries.

DIt enables storing JSON objects directly.

Step-by-Step Solution

Solution:

Step 1: Understand ENUM purpose
ENUM types restrict column values to a fixed set, ensuring only valid data is stored.
Step 2: Compare with TEXT
TEXT columns accept any string, so no inherent validation exists.
Final Answer:
It restricts the column to a predefined set of values, improving data integrity. -> Option B
Quick Check:
ENUM enforces allowed values [OK]

Quick Trick: ENUM limits values to predefined list [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

In PostgreSQL, what is the primary advantage of using an ENUM type over a simple TEXT column?