pg_textsearch extension support on Azure Database for PostgreSQL

Question

Are there any plans to add support for the pg_textsearch extension (https://github.com/timescale/pg_textsearch) to Azure Database for PostgreSQL? This extension offers advanced full-text search capabilities that would be highly beneficial for users who require efficient and flexible text search in their PostgreSQL databases.

Answer 1

Hello **Miguel Silva

I have discussed with my Internal team, and they are currently evaluating the pg_textsearch extension and other capable extensions, though it is not currently on our roadmap. We don't have an ETA yet.

However, we can deliver equivalent search functionality using PostgreSQL’s built‑in full‑text search plus the extensions that are available (pg_trgm, unaccent, dict_xsyn, fuzzystrmatch). This covers fast indexed keyword search, relevance ranking, synonyms, accent-insensitive matching, and optional typo‑tolerance ...etc.