unaccent

text search dictionary that removes accents

https://www.postgresql.org/docs/current/unaccent.html

Overview

Package	Version	Category	License	Language
`unaccent`	`1.1`	FUNC	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
4990	`unaccent`	No	Yes	No	Yes	Yes	No	-

Related	`dict_xsyn` `dict_int` `pg_tokenizer` `pgroonga` `icu_ext` `pg_xenophile` `citext` `pg_trgm`

Version

PG18	PG17	PG16	PG15	PG14
1.1	1.1	1.1	1.1	1.1

Install

Note: This is a built-in contrib extension of PostgreSQL

CREATE EXTENSION unaccent;

Usage

unaccent: text search dictionary for accent removal

Removes accents (diacritic signs) from text. Can be used as a text search dictionary or as a standalone function.

CREATE EXTENSION unaccent;

Functions

Function	Description
`unaccent(text)`	Remove accents using the default dictionary
`unaccent(dictionary regdictionary, text)`	Remove accents using a specific dictionary

Text Search Usage

-- Test the dictionary
SELECT ts_lexize('unaccent', 'Hôtel');
-- {Hotel}

-- Create an accent-insensitive French text search config
CREATE TEXT SEARCH CONFIGURATION fr (COPY = french);
ALTER TEXT SEARCH CONFIGURATION fr
  ALTER MAPPING FOR hword, hword_part, word
  WITH unaccent, french_stem;

SELECT to_tsvector('fr', 'Hôtels de la Mer');
-- 'hotel':1 'mer':4

-- Accent-insensitive search
SELECT to_tsvector('fr', 'Hôtel de la Mer') @@ to_tsquery('fr', 'Hotels');
-- true

Standalone Function Usage

SELECT unaccent('Hôtel');           -- Hotel
SELECT unaccent('café');            -- cafe
SELECT unaccent('résumé');          -- resume
SELECT unaccent('niño');            -- nino

unaccent

Overview

Version

Install

Usage

Functions

Text Search Usage

Standalone Function Usage

Was this page helpful?