How do you correctly add a new value 'inactive' to an existing ENUM type account_status in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - Advanced Features

How do you correctly add a new value 'inactive' to an existing ENUM type account_status in PostgreSQL?

AALTER TYPE account_status ADD 'inactive' AFTER 'active';

BUPDATE TYPE account_status SET VALUES = VALUES + 'inactive';

CALTER ENUM account_status ADD 'inactive';

DALTER TYPE account_status ADD VALUE 'inactive';

Step-by-Step Solution

Solution:

Step 1: Identify correct ALTER TYPE syntax
PostgreSQL uses ALTER TYPE ... ADD VALUE 'value'; to add ENUM values.
Step 2: Check options
Only ALTER TYPE account_status ADD VALUE 'inactive'; uses the correct syntax.
Final Answer:
ALTER TYPE account_status ADD VALUE 'inactive'; -> Option D
Quick Check:
Use ALTER TYPE ... ADD VALUE [OK]

Quick Trick: Use ALTER TYPE ... ADD VALUE to add ENUM values [OK]

Common Mistakes:

Master "Advanced Features" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free