Do you have an idea or suggestion based on your experience with Azure Database for PostgreSQL?

Support for Custom Full Text Search Dictionaries

PostgreSQL supports so many great full text search capabilities that can be really handy in small to mid sized applications without adding the extra overhead of separate search services.

https://www.postgresql.org/docs/9.6/textsearch-dictionaries.html

When self-hosting PG you can add custom dictionaries, with custom synonym, thesaurus, stop word, and other stemming definitions. Currently Azure hosted PostgreSQL doesn't support this, as you'd need access to upload language and dictionary files to use in those definitions. For example, if you want a solid spellchecker via ispell or hunspell you can download those extensions and place them in the $SHAREDIR/tsearch_data directory on the PG server.

Also - this would allow any language to be supported for FTS, which solves many of these other related forum requests for FTS support.

1 vote
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

James S. shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base