Extensions / Functions and aggregates
text search dictionary that removes accents
pgext.cloud · Website · Documentation · License text · Control file
| Package | unaccent |
|---|---|
| Version | 1.1 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | Yes |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| geohistorical_objects | Geohistorical objects support |
| historical_geocoding | SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence. |
| launchql-inflection | inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL |
| pg_slugify | Normalize text into URL-friendly slugs with unaccent |
| pgpm-inflection | PostgreSQL modules using the pgpm workflow for safe, testable, reversible SQL changes. |
| tsp_semantic_headline | Phrase highlighting and improved semantics for ts_headline |
| dict_xsyn | text search dictionary template for extended synonym processing |
| dict_int | text search dictionary template for integers |
| pg_tokenizer | Tokenizers for full-text search |
| pgroonga | Use Groonga as index, fast full text search platform for all languages! |
| icu_ext | Access ICU functions |
| pg_xenophile | More than the bare necessities for PostgreSQL i18n and l10n. |
| citext | data type for case-insensitive character strings |
| pg_trgm | text similarity measurement and index searching based on trigrams |