PostgreSQL: How to remove accents (diacritic signs) from lexemes

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing the use of “unaccent” extension of PostgreSQL.

Use unaccent, for removing diacritic signs from the string and convert into the valid character as per the specified collation.

When we are importing data from different types of datasets, we can find diacritic signs in the data. We can use unaccent() for removing those signs.

Check below demonstration:

Create an extension:

Use unaccent():

Result: