Custom unaccent rules in heroku We have an application running in heroku and we want to add a search feature on a field that contains greek characters and we want to make it accent agnostic.

So the idea is to use postgresql's unaccent functionality. The problem is that by default greek rules are not included at heroku and we somehow need to add them (we already have a rules file).

Has anyone managed to add custom rules files at heroku, and if yes could you please share how?
I contacted Heroku after trying to find a solution for the exact same issue. Here is the response:


  Unfortunately, there is no way to upload that unaccent.rules file to
  the Postgres server that hosts your database. You can enable the
  unaccent extension, but not supply a custom rules files. If this is a
  requirement for your app to run, you will unfortunately have to find a
  workaround that doesn't rely on the unaccent.rules file.


So the shadow column might be the way to go for heroku after all.