unacent_config.py

from django.db.models import Transform


class Trigram(Transform):
    bilateral = True
    lookup_name = 'trigram'

    def as_postgresql(self, compiler, connection):
        lhs, params = compiler.compile(self.lhs)
        return "TRIAGRAM(%s)" % lhs, params


class Unaccent(Transform):
    bilateral = True
    lookup_name = 'unaccent'

    def as_postgresql(self, compiler, connection):
        lhs, params = compiler.compile(self.lhs)
        return "UNACCENT(%s)" % lhs, params


models.CharField.register_lookup(Unaccent)
models.TextField.register_lookup(Unaccent)


models.CharField.register_lookup(Trigram)
models.TextField.register_lookup(Trigram)

unacent_migration.py

from django.contrib.postgres.operations import TrigramExtension
from django.contrib.postgres.operations import UnaccentExtension

class Migration(migrations.Migration):
    operations = [
        TrigramExtension(),
        UnaccentExtension()
    ]

unacent_sql.sql

CREATE EXTENSION unaccent;
CREATE EXTENSION pg_trgm;
CREATE EXTENSION postgis;

CREATE TEXT SEARCH CONFIGURATION unaccent ( COPY = spanish );
ALTER TEXT SEARCH CONFIGURATION unaccent ALTER MAPPING FOR hword, hword_part, word WITH unaccent, simple;