<row>

<entry>American English</entry>

<entry><filename>hunspell_en_us</filename></entry>

<entry><literal>public.english_hunspell</literal></entry>

<entry><literal>public.english</literal></entry>

<entry><literal>english_hunspell</literal></entry>

<entry><literal>english_hunspell</literal></entry>

</row>

<row>

<entry>Dutch</entry>

<entry><filename>hunspell_nl_nl</filename></entry>

<entry><literal>public.dutch_hunspell</literal></entry>

<entry><literal>public.dutch</literal></entry>

<entry><literal>dutch_hunspell</literal></entry>

<entry><literal>dutch_hunspell</literal></entry>

</row>

<row>

<entry>French</entry>

<entry><filename>hunspell_fr</filename></entry>

<entry><literal>public.french_hunspell</literal></entry>

<entry><literal>public.french</literal></entry>

<entry><literal>french_hunspell</literal></entry>

<entry><literal>french_hunspell</literal></entry>

</row>

<row>

<entry>Russian</entry>

<entry><filename>hunspell_ru_ru</filename></entry>

<entry><literal>public.russian_hunspell</literal></entry>

<entry><literal>public.russian</literal></entry>

<entry><literal>russian_hunspell</literal></entry>

<entry><literal>russian_hunspell</literal></entry>

</row>

</tbody>

</tgroup>

We can test created configuration:

<programlisting>

SELECT * FROM ts_debug('public.english', 'abilities');

SELECT * FROM ts_debug('english_hunspell', 'abilities');

alias | description | token | dictionaries | dictionary | lexemes

-----------+-----------------+-----------+---------------------------------+------------------+-----------

asciiword | Word, all ASCII | abilities | {english_hunspell,english_stem} | english_hunspell | {ability}

create mixed russian-english configuration:

<programlisting>

CREATE TEXT SEARCH CONFIGURATIONpublic.russian_en (

COPY =pg_catalog.simple

CREATE TEXT SEARCH CONFIGURATION russian_en (

COPY = simple

);

ALTER TEXT SEARCH CONFIGURATIONpublic.russian_en

ALTER TEXT SEARCH CONFIGURATION russian_en

ALTER MAPPING FOR asciiword, asciihword, hword_asciipart

WITHpublic.english_hunspell,pg_catalog.english_stem;

WITH english_hunspell, english_stem;

ALTER TEXT SEARCH CONFIGURATIONpublic.russian_en

ALTER TEXT SEARCH CONFIGURATION russian_en

ALTER MAPPING FOR word, hword, hword_part

WITHpublic.russian_hunspell,pg_catalog.russian_stem;

WITH russian_hunspell, russian_stem;

</programlisting>

</para>

to use. For example, in this text you can search some words:

<programlisting>

SELECT to_tsvector('public.english', 'The blue whale is the largest animal');

SELECT to_tsvector('english_hunspell', 'The blue whale is the largest animal');

to_tsvector

-----------------------------------------

'animal':7 'blue':2 'large':6 'whale':3

Search query might looks like this:

<programlisting>

SELECT to_tsvector('public.english', 'The blue whale is the largest animal')

@@ to_tsquery('public.english', 'large & whale');

SELECT to_tsvector('english_hunspell', 'The blue whale is the largest animal')

@@ to_tsquery('english_hunspell', 'large & whale');

?column?

----------

t

<programlisting>

CREATE TABLE table1 (t varchar);

INSERT INTO table1 VALUES ('The blue whale is the largest animal');

CREATE INDEX t_idx ON table1 USING GIN (to_tsvector('public.english', "t"));

CREATE INDEX t_idx ON table1 USING GIN (to_tsvector('english_hunspell', "t"));

</programlisting>

</para>

For this table you can execute the following query:

<programlisting>

SELECT * FROM table1 where to_tsvector('public.english', t)

@@ to_tsquery('public.english', 'blue & animal');

SELECT * FROM table1 where to_tsvector('english_hunspell', t)

@@ to_tsquery('english_hunspell', 'blue & animal');

t

--------------------------------------

The blue whale is the largest animal

</para>

</sect2>

</sect1>

</sect1>