2
.\" Title: ALTER TEXT SEARCH DICTIONARY
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.3beta1 Documentation
7
.\" Source: PostgreSQL 9.3beta1
10
.TH "ALTER TEXT SEARCH DICTIONARY" "7" "2013-05-06" "PostgreSQL 9.3beta1" "PostgreSQL 9.3beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * Define some portability stuff
13
.\" -----------------------------------------------------------------
14
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15
.\" http://bugs.debian.org/507673
16
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
20
.\" -----------------------------------------------------------------
21
.\" * set default formatting
22
.\" -----------------------------------------------------------------
23
.\" disable hyphenation
25
.\" disable justification (adjust text to left margin only)
27
.\" -----------------------------------------------------------------
28
.\" * MAIN CONTENT STARTS HERE *
29
.\" -----------------------------------------------------------------
31
ALTER_TEXT_SEARCH_DICTIONARY \- change the definition of a text search dictionary
32
.\" ALTER TEXT SEARCH DICTIONARY
36
ALTER TEXT SEARCH DICTIONARY \fIname\fR (
37
\fIoption\fR [ = \fIvalue\fR ] [, \&.\&.\&. ]
39
ALTER TEXT SEARCH DICTIONARY \fIname\fR RENAME TO \fInew_name\fR
40
ALTER TEXT SEARCH DICTIONARY \fIname\fR OWNER TO \fInew_owner\fR
41
ALTER TEXT SEARCH DICTIONARY \fIname\fR SET SCHEMA \fInew_schema\fR
46
\fBALTER TEXT SEARCH DICTIONARY\fR
47
changes the definition of a text search dictionary\&. You can change the dictionary\*(Aqs template\-specific options, or change the dictionary\*(Aqs name or owner\&.
49
You must be the owner of the dictionary to use
50
\fBALTER TEXT SEARCH DICTIONARY\fR\&.
55
The name (optionally schema\-qualified) of an existing text search dictionary\&.
60
The name of a template\-specific option to be set for this dictionary\&.
65
The new value to use for a template\-specific option\&. If the equal sign and value are omitted, then any previous setting for the option is removed from the dictionary, allowing the default to be used\&.
70
The new name of the text search dictionary\&.
75
The new owner of the text search dictionary\&.
80
The new schema for the text search dictionary\&.
83
Template\-specific options can appear in any order\&.
86
The following example command changes the stopword list for a Snowball\-based dictionary\&. Other parameters remain unchanged\&.
92
ALTER TEXT SEARCH DICTIONARY my_dict ( StopWords = newrussian );
98
The following example command changes the language option to dutch, and removes the stopword option entirely\&.
104
ALTER TEXT SEARCH DICTIONARY my_dict ( language = dutch, StopWords );
110
The following example command
112
the dictionary\*(Aqs definition without actually changing anything\&.
118
ALTER TEXT SEARCH DICTIONARY my_dict ( dummy );
124
(The reason this works is that the option removal code doesn\*(Aqt complain if there is no such option\&.) This trick is useful when changing configuration files for the dictionary: the
126
will force existing database sessions to re\-read the configuration files, which otherwise they would never do if they had read them earlier\&.
130
\fBALTER TEXT SEARCH DICTIONARY\fR
131
statement in the SQL standard\&.
133
CREATE TEXT SEARCH DICTIONARY (\fBCREATE_TEXT_SEARCH_DICTIONARY\fR(7)), DROP TEXT SEARCH DICTIONARY (\fBDROP_TEXT_SEARCH_DICTIONARY\fR(7))