Hunspell dictionaries

Introduction

The repository contains hunspell dictionaries for several languages listed below.

Installation

Here the example of installation of the english dictionary:

$ git clone https://github.com/postgrespro/hunspell_dicts
$ cd hunspell_dicts/hunspell_en_us
$ make USE_PGXS=1 install
$ make USE_PGXS=1 installcheck
$ psql DB -c "CREATE EXTENSION hunspell_en_us;"

Important: Don't forget to set the PG_CONFIG variable in case you want to test dictionaries on a custom build of PostgreSQL. Read more here.

After the installation you can use english dictionary and configuration:

=> SELECT ts_lexize('english_hunspell', 'stories');
 ts_lexize
-----------
 {story}
(1 row)

=> SELECT to_tsvector('english_hunspell', 'stories');
 to_tsvector
-------------
 'story':1
(1 row)

Custom installation

If you want to create a dictionary which isn't listed below, you may want to download necessary OpenOffice or LibreOffice extension.

Then you need to do the following (from the documentation):

• OpenOffice/LibreOffice extension files have the .oxt extension. It is necessary to extract .aff and .dic files, change extensions to .affix and .dict. For some dictionary files it is also needed to convert characters to the UTF-8 encoding with commands (for example, for a Norwegian language dictionary):

  iconv -f ISO_8859-1 -t UTF-8 -o nn_no.affix nn_NO.aff
  iconv -f ISO_8859-1 -t UTF-8 -o nn_no.dict nn_NO.dic

• copy files to the $SHAREDIR/tsearch_data directory
• load files into PostgreSQL with the following command:

  CREATE TEXT SEARCH DICTIONARY norwegian_hunspell (
  TEMPLATE = ispell,
  DictFile = nn_no,
  AffFile = nn_no,
  StopWords = norwegian
  );

New dictionaries and configurations

The modules introduce the following dictionaries and configurations: