---
name: "pg_updatedicts"
section: "8"
platform: "linux"
package: "postgresql-common"
version: "278"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/pg_updatedicts"
---

# pg\_updatedicts(8)

build PostgreSQL dictionaries from myspell/hunspell ones

## NAME

pg\_updatedicts - build PostgreSQL dictionaries from myspell/hunspell ones

## SYNOPSIS

**pg\_updatedicts**

## DESCRIPTION

**pg\_updatedicts** makes dictionaries and affix files from installed myspell and hunspell dictionary packages available to PostgreSQL for usage with tsearch and word stem support. In particular, it takes all *\*.dic* and *\*.aff* files from /usr/share/myspell/dicts/, converts them to UTF-8, puts them into /var/cache/postgresql/dicts/ with *\*.dict* and *\*.affix* suffixes, and symlinks them into /usr/share/postgresql/*version*/tsearch\_data/, where PostgreSQL looks for them.

Through postgresql-common's dpkg trigger, this program is automatically run whenever a myspell or hunspell dictionary package is installed or upgraded.

## AUTHOR

Martin Pitt \<mpitt@debian.org\>