Blog Archive for July 16, 2010

Soundex function in postgres

July 16, 2010

The soundex function is not installed by default in the postgres database. To install on debian lenny:

$ apt-get install postgresql-contrib

This installs the script. You now need to run the fuzzystrmatch.sql script to install the function.

host:/home/drumcoder# su postgres
postgres@host:/home/drumcoder$ psql

Welcome to psql 8.3.11, the PostgreSQL interactive terminal. …