How to use the Accent insensitive option

To use this option in applications that use PostgreSQL it will be necessary to enable the UNACCENT extension.

This extension is natively available in PostgreSQL as of version 10

Enabling extension

1 - Connect to your DB instance as a user who has administrator privileges.

If you do not have access to the admin user of your database, contact your DBA or your shared hosting support

2 - To activate the extension, use the CREATE EXTENSION command as shown below.

1. CREATE EXTENSION unaccent;

Now your database will have the extension enabled and the Accent insensitive feature can be used.

This procedure must be performed individually for each database

Check if the extension is available in your PostgreSQL

The UNACCENT extension is available natively in your PostgreSQL database starting with version 10.

However, it can be used from version 9.5.24 onwards.

To check if the extension is available in your database, run the command below:

1. SELECT * FROM pg_available_extensions() WHERE name = 'unaccent';

When available this will be the result: