Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Create unique index

Enforce uniqueness with an index.

Back to sheetBrowse commands
Sign in to save
Section: Indexes and Constraints

Create unique index

sql
sql
CREATE UNIQUE INDEX idx_users_email_unique ON public.users (email);
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Indexes and Constraints
Create index
Add a basic B-tree index to speed lookups.
OpenIn sheetsqlsame section
Create index concurrently
Build an index with reduced write blocking.
OpenIn sheetsqlsame section
Create partial index
Index only a subset of rows.
OpenIn sheetsqlsame section
Create expression index
Index an expression for case-insensitive lookups.
OpenIn sheetsqlsame section
Create GIN index on JSONB
Accelerate JSONB containment queries.
OpenIn sheetsqlsame section
Add unique constraint
Ensure unique values through a table constraint.
OpenIn sheetsqlsame section