2
.\" Title: ALTER TEXT SEARCH CONFIGURATION
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "ALTER TEXT SEARCH CONFIGURATION" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
ALTER_TEXT_SEARCH_CONFIGURATION \- change the definition of a text search configuration
23
.\" ALTER TEXT SEARCH CONFIGURATION
27
ALTER TEXT SEARCH CONFIGURATION \fIname\fR
28
ADD MAPPING FOR \fItoken_type\fR [, \&.\&.\&. ] WITH \fIdictionary_name\fR [, \&.\&.\&. ]
29
ALTER TEXT SEARCH CONFIGURATION \fIname\fR
30
ALTER MAPPING FOR \fItoken_type\fR [, \&.\&.\&. ] WITH \fIdictionary_name\fR [, \&.\&.\&. ]
31
ALTER TEXT SEARCH CONFIGURATION \fIname\fR
32
ALTER MAPPING REPLACE \fIold_dictionary\fR WITH \fInew_dictionary\fR
33
ALTER TEXT SEARCH CONFIGURATION \fIname\fR
34
ALTER MAPPING FOR \fItoken_type\fR [, \&.\&.\&. ] REPLACE \fIold_dictionary\fR WITH \fInew_dictionary\fR
35
ALTER TEXT SEARCH CONFIGURATION \fIname\fR
36
DROP MAPPING [ IF EXISTS ] FOR \fItoken_type\fR [, \&.\&.\&. ]
37
ALTER TEXT SEARCH CONFIGURATION \fIname\fR RENAME TO \fInew_name\fR
38
ALTER TEXT SEARCH CONFIGURATION \fIname\fR OWNER TO \fInew_owner\fR
39
ALTER TEXT SEARCH CONFIGURATION \fIname\fR SET SCHEMA \fInew_schema\fR
43
ALTER TEXT SEARCH CONFIGURATION
44
changes the definition of a text search configuration\&. You can modify its mappings from token types to dictionaries, or change the configuration\(aqs name or owner\&.
46
You must be the owner of the configuration to use
47
ALTER TEXT SEARCH CONFIGURATION\&.
52
The name (optionally schema\-qualified) of an existing text search configuration\&.
57
The name of a token type that is emitted by the configuration\(aqs parser\&.
62
The name of a text search dictionary to be consulted for the specified token type(s)\&. If multiple dictionaries are listed, they are consulted in the specified order\&.
67
The name of a text search dictionary to be replaced in the mapping\&.
72
The name of a text search dictionary to be substituted for
73
\fIold_dictionary\fR\&.
78
The new name of the text search configuration\&.
83
The new owner of the text search configuration\&.
88
The new schema for the text search configuration\&.
93
form installs a list of dictionaries to be consulted for the specified token type(s); it is an error if there is already a mapping for any of the token types\&. The
95
form does the same, but first removing any existing mapping for those token types\&. The
101
anywhere the latter appears\&. This is done for only the specified token types when
103
appears, or for all mappings of the configuration when it doesn\(aqt\&. The
105
form removes all dictionaries for the specified token type(s), causing tokens of those types to be ignored by the text search configuration\&. It is an error if there is no mapping for the token types, unless
110
The following example replaces the
114
dictionary anywhere that
123
ALTER TEXT SEARCH CONFIGURATION my_config
124
ALTER MAPPING REPLACE english WITH swedish;
132
ALTER TEXT SEARCH CONFIGURATION
133
statement in the SQL standard\&.
135
CREATE TEXT SEARCH CONFIGURATION (\fBCREATE_TEXT_SEARCH_CONFIGURATION\fR(7)), DROP TEXT SEARCH CONFIGURATION (\fBDROP_TEXT_SEARCH_CONFIGURATION\fR(7))