0

I need to do queries ignoring diacritics (and case) in PostgreSQL 9.3. Everything I've found about it (e.g. here, here and here) requires the installation of the unaccent extension. However, I cannot have it installed on my server.

Is there another way to do it?

Rodrigo
  • 4,706
  • 6
  • 51
  • 94
  • Upgrade to a recent version and use case and accent insensitive ICU collations, which you can define yourself. If you cannot upgrade, and you cannot install an extension, you have to accept that you are too limited to get what you want. – Laurenz Albe Nov 21 '21 at 02:34
  • @LaurenzAlbe I guess you mean PostgreSQL 12? – Rodrigo Nov 21 '21 at 02:41
  • 2
    Technically yes, but at this point it would be silly to upgrade to anything less than v13, and I would recommend v14. – Laurenz Albe Nov 21 '21 at 02:43

0 Answers0