Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Enable citext

Install case-insensitive text type support.

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

Enable citext

sql
sql
CREATE EXTENSION IF NOT EXISTS 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 pg_trgm
Install trigram support for similarity search and GIN/GiST indexes.
OpenIn sheetsqlsame section
Use CITEXT
Make a column case-insensitive with the `citext` type.
OpenIn sheetsqlsame section
Enable pgstattuple
Install size and tuple-stat inspection helpers.
OpenIn sheetsqlsame section
Enable uuid-ossp
Install UUID generation helpers.
OpenIn sheetsqlsame section
Create trigram index
Accelerate ILIKE and fuzzy matches on text.
OpenIn sheetsqlsame section
Check table bloat stats
Estimate dead tuples and free space in a relation.
OpenIn sheetsqlsame section