Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Add unique constraint

Ensure unique values through a table constraint.

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

Add unique constraint

sql
sql
ALTER TABLE public.users ADD CONSTRAINT users_email_key UNIQUE (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 unique index
Enforce uniqueness with an index.
OpenIn sheetsqlsame section
Add primary key
Define a primary key after table creation.
OpenIn sheetsqlsame section
Add foreign key
Link rows to a parent table with referential integrity.
OpenIn sheetsqlsame section
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