oswilno/README.md
2023-04-24 16:11:49 +02:00

27 lines
667 B
Markdown

# 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;
```