# OS Wilno

## PostgreSQL dictionary

https://github.com/dominem/postgresql_fts_polish_dict

```
cp db/dictionary/polish.dict /usr/share/postgresql/tsearch_data/polish.dict
cp db/dictionary/polish.affix /usr/share/postgresql/tsearch_data/polish.affix
cp db/dictionary/polish.stop /usr/share/postgresql/tsearch_data/polish.stop
```

```sql
CREATE TEXT SEARCH DICTIONARY polish (
  Template = ispell,
  DictFile = polish,
  AffFile = polish,
  StopWords = polish
);

CREATE TEXT SEARCH CONFIGURATION polish(parser = default);

ALTER TEXT SEARCH CONFIGURATION polish
  ALTER MAPPING FOR asciiword, asciihword, hword_asciipart, word, hword, hword_part
  WITH polish;
```