Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Use CITEXT

Make a column case-insensitive with the `citext` type.

Back to sheetBrowse commands
Sign in to save
Section: Extensions and Specialized Utilities

Use CITEXT

sql
sql
ALTER TABLE public.users ALTER COLUMN email TYPE citext;
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 Extensions and Specialized Utilities
Enable citext
Install case-insensitive text type support.
OpenIn sheetsqlsame section
Enable pg_trgm
Install trigram support for similarity search and GIN/GiST indexes.
OpenIn sheetsqlsame section
Create trigram index
Accelerate ILIKE and fuzzy matches on text.
OpenIn sheetsqlsame section
Enable pgstattuple
Install size and tuple-stat inspection helpers.
OpenIn sheetsqlsame section
Check table bloat stats
Estimate dead tuples and free space in a relation.
OpenIn sheetsqlsame section
Enable uuid-ossp
Install UUID generation helpers.
OpenIn sheetsqlsame section