ext::pg_unaccentAdded in v4.0​

.md

Copy page

This extension provides a dictionary for removing accents (diacritic signs) from text.

db> 

select ext::pg_unaccent::unaccent('Hôtel de la Mer');

{'Hotel de la Mer'}

To activate this functionality you can use the extension mechanism:

using extension pg_unaccent;

That will give you access to the ext::pg_unaccent module where you may find the function unaccent.

PostgreSQL extension unaccent also supports creating dictionaries that are used by other PostgreSQL text search, such as to_tsvector. Gel extension currently does not support creating such dictionaries, but one can use the unaccent function to achieve the same effect:

type Post {
    title: str;

    index fts::index on ((
        fts::with_options(
            ext::pg_unaccent::unaccent(.title),
            language := fts::Language.fra
        ),
    ));
};

db> 
... 
... 
... 
... 

select fts::search(
  Post,
  ext::pg_unaccent::unaccent('Hôtel'),
  language := 'eng',
).object.title;

{'Hôtel de la Mer'}