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

Install trigram support for similarity search and GIN/GiST indexes.

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

Enable pg_trgm

sql
sql
CREATE EXTENSION IF NOT EXISTS pg_trgm;
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
Create trigram index
Accelerate ILIKE and fuzzy matches on text.
OpenIn sheetsqlsame section
Enable citext
Install case-insensitive text type support.
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
Use CITEXT
Make a column case-insensitive with the `citext` type.
OpenIn sheetsqlsame section
Check table bloat stats
Estimate dead tuples and free space in a relation.
OpenIn sheetsqlsame section