Installing a language dictionary (Continued)

Copy the simple configuration into the new default_english configuration.

INSERT INTO pg_ts_cfgmap (ts_name, tok_alias, dict_name)
SELECT 'default_english', tok_alias, dict_name from pg_ts_cfgmap
	WHERE ts_name = 'simple';

Update the default_english configuration to parse using the english dictionary if possible and the algorithmic stemmer if a word is not found.

UPDATE pg_ts_cfgmap set dict_name = '{en_ispell,en_stem}'
WHERE ts_name = 'default_english' AND tok_alias in ('lhword', 'lpart_hword', 'lword');