{"Entry":{"collection":"sql","key":"alter-text-search-configuration","name":"ALTER TEXT SEARCH CONFIGURATION","aliases":["altertsconfig"],"metadata":{"aliases":["altertsconfig"],"changed_in":["9.0","9.1","9.5","14"],"changes":[{"from":"8.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"added","synopsis":null,"to":"8.3"},{"from":"8.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["ALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name","ALTER TEXT SEARCH CONFIGURATION name OWNER TO new_owner"],"removed":["ALTER TEXT SEARCH CONFIGURATION name RENAME TO newname","ALTER TEXT SEARCH CONFIGURATION name OWNER TO newowner"]},"to":"9.0"},{"from":"9.0","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["ALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema"],"removed":[]},"to":"9.1"},{"from":"9.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["ALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }"],"removed":[]},"to":"9.5"},{"from":"13","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":{"added":["ALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }"],"removed":[]},"to":"14"}],"content_hash":"0a0e7d948b8d02e4ec31b49393e205510294fbe67f5d57bde3bd72e493d667b5","editorial":{},"first_version":"8.3","group":"textsearch","imported_at":"2026-09-30T17:43:38.574588+08:00","last_version":"20","name":"ALTER TEXT SEARCH CONFIGURATION","object":"TEXT SEARCH CONFIGURATION","position":8001,"present_in":["8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"purpose":"change the definition of a text search configuration","purpose_zh":"","related":["create-text-search-configuration","drop-text-search-configuration"],"slug":"alter-text-search-configuration","source_rev":"a709ab85","synopsis":"ALTER TEXT SEARCH CONFIGURATION name\nADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nDROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]\nALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name\nALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema","verb":"ALTER"}},"Definition":{"Collection":"sql","Key":"alter-text-search-configuration","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"alter-text-search-configuration","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-ALTERTSCONFIG","file":"sql-altertsconfig.html","lang":"en","name":"ALTER TEXT SEARCH CONFIGURATION","purpose":"change the definition of a text search configuration","purpose_zh":"","related":["create-text-search-configuration","drop-text-search-configuration"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e changes the definition of a text search configuration. You can modify its mappings from token types to dictionaries, or change the configuration's name or owner.\u003c/p\u003e\u003cp\u003eYou must be the owner of the configuration to use \u003ccode class=\"command\"\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e.\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name (optionally schema-qualified) of an existing text search configuration.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of a token type that is emitted by the configuration's parser.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe 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.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of a text search dictionary to be replaced in the mapping.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of a text search dictionary to be substituted for \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new name of the text search configuration.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new owner of the text search configuration.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe new schema for the text search configuration.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003cp\u003eThe \u003ccode class=\"literal\"\u003eADD MAPPING FOR\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003eALTER MAPPING FOR\u003c/code\u003e form does the same, but first removing any existing mapping for those token types. The \u003ccode class=\"literal\"\u003eALTER MAPPING REPLACE\u003c/code\u003e forms substitute \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e for \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e anywhere the latter appears. This is done for only the specified token types when \u003ccode class=\"literal\"\u003eFOR\u003c/code\u003e appears, or for all mappings of the configuration when it doesn't. The \u003ccode class=\"literal\"\u003eDROP MAPPING\u003c/code\u003e 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 \u003ccode class=\"literal\"\u003eIF EXISTS\u003c/code\u003e appears.\u003c/p\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eThe following example replaces the \u003ccode class=\"literal\"\u003eenglish\u003c/code\u003e dictionary with the \u003ccode class=\"literal\"\u003eswedish\u003c/code\u003e dictionary anywhere that \u003ccode class=\"literal\"\u003eenglish\u003c/code\u003e is used within \u003ccode class=\"literal\"\u003emy_config\u003c/code\u003e.\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER TEXT SEARCH CONFIGURATION my_config\n  ALTER MAPPING REPLACE english WITH swedish;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003eThere is no \u003ccode class=\"command\"\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e statement in the SQL standard.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-text-search-configuration/?v=18\" title=\"CREATE TEXT SEARCH CONFIGURATION\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE TEXT SEARCH CONFIGURATION\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-text-search-configuration/?v=18\" title=\"DROP TEXT SEARCH CONFIGURATION\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP TEXT SEARCH CONFIGURATION\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"ALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ADD MAPPING FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ] WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ALTER MAPPING FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ] WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ALTER MAPPING REPLACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ALTER MAPPING FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ] REPLACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    DROP MAPPING [ IF EXISTS ] FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e OWNER TO { \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e SET SCHEMA \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ALTER TEXT SEARCH CONFIGURATION name\nADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nDROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]\nALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name\nALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"alter-text-search-configuration","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"ALTER TEXT SEARCH CONFIGURATION","Summary":"更改一个文本检索配置的定义","BodyHTML":"\u003cpre\u003eALTER TEXT SEARCH CONFIGURATION name\nADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nDROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]\nALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name\nALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e 更改一个文本检索配置的定义。你可以修改其从词元类型到词典的映射，或者更改该配置的名称或拥有者。\u003c/p\u003e\u003cp\u003e要使用\u003ccode\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e，你必须是该配置的拥有者。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e一个现有文本检索配置的名称（可以是模式限定的）。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e由该配置的解析器发出的词元类型的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e用于指定词元类型的文本检索词典名称。如果列出了多个词典，将按指定顺序依次查阅它们。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e在映射中要替换的文本检索词典的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e被用来替代\u003cem\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e 的文本检索词典的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该文本检索配置的新名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该文本检索配置的新拥有者。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该文本检索配置的新模式。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003cp\u003e\u003ccode\u003eADD MAPPING FOR\u003c/code\u003e形式会为指定词元类型设置要查阅的词典列表；如果任一词元类型已经有映射，则会报错。\u003ccode\u003eALTER MAPPING FOR\u003c/code\u003e 形式作用相同，但会先移除这些词元类型的任何现有映射。\u003ccode\u003eALTER MAPPING REPLACE\u003c/code\u003e形式会在 \u003cem\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e出现的任何位置，用\u003cem\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e替换它。如果出现\u003ccode\u003eFOR\u003c/code\u003e，则只对指定的词元类型这样做；如果未出现 \u003ccode\u003eFOR\u003c/code\u003e，则对该配置的所有映射这样做。\u003ccode\u003eDROP MAPPING\u003c/code\u003e形式会移除指定词元类型的所有词典，使这些类型的词元被文本检索配置忽略。除非出现\u003ccode\u003eIF EXISTS\u003c/code\u003e，否则如果这些词元类型没有映射就会报错。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e下面的示例将\u003ccode\u003emy_config\u003c/code\u003e中所有使用的\u003ccode\u003eenglish\u003c/code\u003e词典替换为\u003ccode\u003eswedish\u003c/code\u003e词典。\u003c/p\u003e\u003cpre\u003eALTER TEXT SEARCH CONFIGURATION my_config\n  ALTER MAPPING REPLACE english WITH swedish;\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e在 SQL 标准中没有 \u003ccode\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e 语句。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/create-text-search-configuration/?v=18\" title=\"CREATE TEXT SEARCH CONFIGURATION\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE TEXT SEARCH CONFIGURATION\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-text-search-configuration/?v=18\" title=\"DROP TEXT SEARCH CONFIGURATION\" rel=\"nofollow\"\u003e\u003cspan\u003eDROP TEXT SEARCH CONFIGURATION\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"3b6ecdf3cd4f5c51977de57eaf3701007604b8ee61ab49d58e8d99685d662b26","Payload":{"purpose_zh":"更改一个文本检索配置的定义","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e 更改一个文本检索配置的定义。你可以修改其从词元类型到词典的映射，或者更改该配置的名称或拥有者。\u003c/p\u003e\u003cp\u003e要使用\u003ccode class=\"command\"\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e，你必须是该配置的拥有者。\u003c/p\u003e","key":"description","title":"描述"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e一个现有文本检索配置的名称（可以是模式限定的）。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e由该配置的解析器发出的词元类型的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e用于指定词元类型的文本检索词典名称。如果列出了多个词典，将按指定顺序依次查阅它们。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e在映射中要替换的文本检索词典的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e被用来替代\u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e 的文本检索词典的名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该文本检索配置的新名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该文本检索配置的新拥有者。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e该文本检索配置的新模式。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003cp\u003e\u003ccode class=\"literal\"\u003eADD MAPPING FOR\u003c/code\u003e形式会为指定词元类型设置要查阅的词典列表；如果任一词元类型已经有映射，则会报错。\u003ccode class=\"literal\"\u003eALTER MAPPING FOR\u003c/code\u003e 形式作用相同，但会先移除这些词元类型的任何现有映射。\u003ccode class=\"literal\"\u003eALTER MAPPING REPLACE\u003c/code\u003e形式会在 \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e出现的任何位置，用\u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e替换它。如果出现\u003ccode class=\"literal\"\u003eFOR\u003c/code\u003e，则只对指定的词元类型这样做；如果未出现 \u003ccode class=\"literal\"\u003eFOR\u003c/code\u003e，则对该配置的所有映射这样做。\u003ccode class=\"literal\"\u003eDROP MAPPING\u003c/code\u003e形式会移除指定词元类型的所有词典，使这些类型的词元被文本检索配置忽略。除非出现\u003ccode class=\"literal\"\u003eIF EXISTS\u003c/code\u003e，否则如果这些词元类型没有映射就会报错。\u003c/p\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e下面的示例将\u003ccode class=\"literal\"\u003emy_config\u003c/code\u003e中所有使用的\u003ccode class=\"literal\"\u003eenglish\u003c/code\u003e词典替换为\u003ccode class=\"literal\"\u003eswedish\u003c/code\u003e词典。\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eALTER TEXT SEARCH CONFIGURATION my_config\n  ALTER MAPPING REPLACE english WITH swedish;\n\u003c/pre\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e在 SQL 标准中没有 \u003ccode class=\"command\"\u003eALTER TEXT SEARCH CONFIGURATION\u003c/code\u003e 语句。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-text-search-configuration/?v=18\" title=\"CREATE TEXT SEARCH CONFIGURATION\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE TEXT SEARCH CONFIGURATION\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-text-search-configuration/?v=18\" title=\"DROP TEXT SEARCH CONFIGURATION\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP TEXT SEARCH CONFIGURATION\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"ALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ADD MAPPING FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ] WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ALTER MAPPING FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ] WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003edictionary_name\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ALTER MAPPING REPLACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    ALTER MAPPING FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ] REPLACE \u003cem class=\"replaceable\"\u003e\u003ccode\u003eold_dictionary\u003c/code\u003e\u003c/em\u003e WITH \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_dictionary\u003c/code\u003e\u003c/em\u003e\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\n    DROP MAPPING [ IF EXISTS ] FOR \u003cem class=\"replaceable\"\u003e\u003ccode\u003etoken_type\u003c/code\u003e\u003c/em\u003e [, ... ]\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e RENAME TO \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_name\u003c/code\u003e\u003c/em\u003e\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e OWNER TO { \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_owner\u003c/code\u003e\u003c/em\u003e | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER TEXT SEARCH CONFIGURATION \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e SET SCHEMA \u003cem class=\"replaceable\"\u003e\u003ccode\u003enew_schema\u003c/code\u003e\u003c/em\u003e","synopsis_text":"ALTER TEXT SEARCH CONFIGURATION name\nADD MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] WITH dictionary_name [, ... ]\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nALTER MAPPING FOR token_type [, ... ] REPLACE old_dictionary WITH new_dictionary\nALTER TEXT SEARCH CONFIGURATION name\nDROP MAPPING [ IF EXISTS ] FOR token_type [, ... ]\nALTER TEXT SEARCH CONFIGURATION name RENAME TO new_name\nALTER TEXT SEARCH CONFIGURATION name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }\nALTER TEXT SEARCH CONFIGURATION name SET SCHEMA new_schema"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}