Cloud SQL Postgres unaccent custom rules

[carlcrede]

I want to use custom rules for the unaccent extension (Postgres 14), however since I cannot access the files of the managed db it's not possible to add the file to the $SHAREDIR/tsearch_data/ directory as the postgres unaccent documentation  suggests.
So I'm wondering if there is some other way to do this, or maybe this is just a natural limitation of the managed db concept.

[christianpaula]

Hi @carlcrede,

Welcome to Google Cloud Community!

• Custom unaccent rules are not directly supported in Cloud SQL Postgres due to managed service restrictions.
• Pre-built dictionaries or application-layer unaccenting logic are alternative approaches.
• Consider using libraries like pg_catalog.unaccent or language-specific tools for unaccenting.