PostgreSQL specific lookups

    To use it, add 'django.contrib.postgres' in your INSTALLED_APPS and activate the on PostgreSQL. You can install the extension using the TrigramExtension migration operation.

    The trigram_similar lookup can be used on and TextField:

    New in Django 4.0.

    To use it, add 'django.contrib.postgres' in your and activate the pg_trgm extension on PostgreSQL. You can install the extension using the migration operation.

    The trigram_word_similar lookup can be used on CharField and :

    Unaccent

    The lookup allows you to perform accent-insensitive lookups using a dedicated PostgreSQL extension.

    The unaccent lookup can be used on and TextField:

    Warning

    unaccent lookups should perform fine in most use cases. However, queries using this filter will generally perform full table scans, which can be slow on large tables. In those cases, using dedicated full text indexing tools might be appropriate.