Postgresql 中文操作指南
ALTER TEXT SEARCH DICTIONARY
ALTER TEXT SEARCH DICTIONARY – 更改文本搜索词典的定义
ALTER TEXT SEARCH DICTIONARY — change the definition of a text search dictionary
Synopsis
ALTER TEXT SEARCH DICTIONARY name (
option [ = value ] [, ... ]
)
ALTER TEXT SEARCH DICTIONARY name RENAME TO new_name
ALTER TEXT SEARCH DICTIONARY name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
ALTER TEXT SEARCH DICTIONARY name SET SCHEMA new_schemaDescription
ALTER TEXT SEARCH DICTIONARY 更改文本搜索词典的定义。您可以更改词典的模板特定选项或更改词典的名称或所有者。
ALTER TEXT SEARCH DICTIONARY changes the definition of a text search dictionary. You can change the dictionary’s template-specific options, or change the dictionary’s name or owner.
要使用 ALTER TEXT SEARCH DICTIONARY ，您必须是该词典的所有者。
You must be the owner of the dictionary to use ALTER TEXT SEARCH DICTIONARY.
Parameters
-
name
-
The name (optionally schema-qualified) of an existing text search dictionary.
-
-
option
-
The name of a template-specific option to be set for this dictionary.
-
-
value
-
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.
-
-
new_name
-
The new name of the text search dictionary.
-
-
new_owner
-
The new owner of the text search dictionary.
-
-
new_schema
-
The new schema for the text search dictionary.
-
特定于模板的选项可以按任何顺序出现。
Template-specific options can appear in any order.
Examples
以下示例命令更改基于 Snowball 的词典的停止词列表。其他参数保持不变。
The following example command changes the stopword list for a Snowball-based dictionary. Other parameters remain unchanged.
ALTER TEXT SEARCH DICTIONARY my_dict ( StopWords = newrussian );以下示例命令将语言选项更改为 dutch ，并完全删除停止词选项。
The following example command changes the language option to dutch, and removes the stopword option entirely.
ALTER TEXT SEARCH DICTIONARY my_dict ( language = dutch, StopWords );以下示例命令“更新”词典的定义而不实际更改任何内容。
The following example command “updates” the dictionary’s definition without actually changing anything.
ALTER TEXT SEARCH DICTIONARY my_dict ( dummy );（这样做有效的原因是，如果没有这样的选项，选项删除代码不会发出抱怨。）在更改词典的配置文件时，此技巧很有用： ALTER 将强制现有数据库会话重新读取配置文件，否则它们在先前已读取的情况下永远不会执行此操作。
(The reason this works is that the option removal code doesn’t complain if there is no such option.) This trick is useful when changing configuration files for the dictionary: the ALTER will force existing database sessions to re-read the configuration files, which otherwise they would never do if they had read them earlier.