Full-Text Search in PostgreSQL: A Gentle Introduction
PrevFast BackwardFast ForwardNext

ALTER FULLTEXT MAPPING

Name

ALTER FULLTEXT MAPPING -- change token binding with FTS dictionaries

Synopsis

ALTER FULLTEXT MAPPING ON cfgname FOR tokentypename[, ...] WITH dictname1[, ...];
ALTER FULLTEXT MAPPING ON cfgname [FOR tokentypename[, ...] ] REPLACE olddictname TO newdictname;

Description

ALTER FULLTEXT MAPPING change binding of token of tokentypename or create one if binding doesn't exists.

Parameters

cfgname

The name (optionally schema-qualified) of the full-text configuration.

FOR

tokentypename is the type of token full-text mapping created for.

WITH

dictname1 is the name of full-text dictionary, which binds to the tokentypename.

REPLACE

olddictname is the name of full-text dictionary to be replaced by a newdictname.

TO

newdictname is the name of full-text dictionary, which replaces olddictname.

Examples

=# ALTER FULLTEXT MAPPING ON testcfg FOR lword WITH simple;
ALTER FULLTEXT MAPPING
=# ALTER FULLTEXT MAPPING ON testcfg FOR lhword WITH simple,en_stem;
ALTER FULLTEXT MAPPING
=# \dF+ testcfg
 Configuration 'testcfg'
Parser name: 'default'
Locale: 'testlocale'
 Token  |  Dictionaries
--------+----------------
 lhword | simple,en_stem
 lword  | simple

See Also

CREATE FULLTEXT MAPPING
PrevHomeNext
CREATE FULLTEXT MAPPINGUpDROP FULLTEXT MAPPING