Use the whpg-cjk extension to run full text search for Korean, Japanese, and Chinese in WarehousePG (WHPG). It's based on morphological analysis rather than N-gram splitting, so it matches on words instead of arbitrary character sequences.

The extension produces ordinary tsvector and tsquery values. Generalized Inverted Index (GIN) and Generalized Search Tree (GiST) indexes, the @@ operator, ts_rank, and ts_headline work unchanged. On WarehousePG, the queries run on the segments like any other predicate.

To get started with whpg-cjk, see:

Release notes

Release notes for the whpg-cjk extension for WarehousePG.

Installing

Install, register, and preload the whpg-cjk extension for WarehousePG.

Using

Index and search Korean, Japanese, and Chinese text in WarehousePG with the text search configurations that the whpg-cjk extension provides.


Could this page be better? Report a problem or suggest an addition!