Postgres can use Ispell-compatible dictionaries in text search, but does not provide the required files.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
This example uses the Canadian English dictionary, but you can try it with others as well.
I wrote a little Java program to get, clean, merge, and sort the dictionaries, with correct UTF-8 behaviour
You can compile it youself or download https://bitbucket.org/neilmcg/postgresql-ispell-importer/downloads/postgres-ispell.jar and run
where $local is like
This will create
[Older manual steps]
These are the steps needed for Windows:
In PgAdmin, run the following SQL:
You will need to create a new text search configuration to use the dictionary.
I've written the following script to install an en_us dictionary on Ubuntu 14.04 running PostgreSQL 9.4. It should be fairly easy to modify for most situations.
This is covered in detail in the PostgreSQL manual, under ISpell Dictionaries.
Essentially you just