pgsearch custom dictionary & configuration

gistfile1.txt

# 1. Create config
CREATE TEXT SEARCH CONFIGURATION public.my_config ( COPY = pg_catalog.spanish );

# 2. Create dictionary
CREATE TEXT SEARCH DICTIONARY public.my_dict ( TEMPLATE = pg_catalog.simple, STOPWORDS = russian);

# 3. Alter config
ALTER TEXT SEARCH CONFIGURATION public.my_config ALTER MAPPING FOR asciiword, asciihword, hword_asciipart, hword, hword_part, word WITH my_dict;

# 4. ????
CREATE INDEX body_idx ON comments USING gin (to_tsvector('german_nostop', body));