{"Entry":{"collection":"sql","key":"alter-text-search-parser","name":"ALTER TEXT SEARCH PARSER","aliases":["altertsparser"],"metadata":{"aliases":["altertsparser"],"changed_in":["9.0","9.1"],"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 PARSER name RENAME TO new_name"],"removed":["ALTER TEXT SEARCH PARSER name RENAME TO newname"]},"to":"9.0"},{"from":"9.0","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["ALTER TEXT SEARCH PARSER name SET SCHEMA new_schema"],"removed":[]},"to":"9.1"}],"content_hash":"1e5d4c7b809162c25ecd1c7e6b6b3a23f64227b7c49b781c766607149b213b5c","editorial":{},"first_version":"8.3","group":"textsearch","imported_at":"2026-09-30T17:43:38.628318+08:00","last_version":"20","name":"ALTER TEXT SEARCH PARSER","object":"TEXT SEARCH PARSER","position":8007,"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 parser","purpose_zh":"","related":["create-text-search-parser","drop-text-search-parser"],"slug":"alter-text-search-parser","source_rev":"a709ab85","synopsis":"ALTER TEXT SEARCH PARSER name RENAME TO new_name\nALTER TEXT SEARCH PARSER name SET SCHEMA new_schema","verb":"ALTER"}},"Definition":{"Collection":"sql","Key":"alter-text-search-parser","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"alter-text-search-parser","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-ALTERTSPARSER","file":"sql-altertsparser.html","lang":"en","name":"ALTER TEXT SEARCH PARSER","purpose":"change the definition of a text search parser","purpose_zh":"","related":["create-text-search-parser","drop-text-search-parser"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER TEXT SEARCH PARSER\u003c/code\u003e changes the definition of a text search parser. Currently, the only supported functionality is to change the parser's name.\u003c/p\u003e\u003cp\u003eYou must be a superuser to use \u003ccode class=\"command\"\u003eALTER TEXT SEARCH PARSER\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 parser.\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 parser.\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 parser.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003eThere is no \u003ccode class=\"command\"\u003eALTER TEXT SEARCH PARSER\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-parser/?v=18\" title=\"CREATE TEXT SEARCH PARSER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE TEXT SEARCH PARSER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-text-search-parser/?v=18\" title=\"DROP TEXT SEARCH PARSER\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP TEXT SEARCH PARSER\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 PARSER \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 PARSER \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 PARSER name RENAME TO new_name\nALTER TEXT SEARCH PARSER name SET SCHEMA new_schema"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"alter-text-search-parser","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"ALTER TEXT SEARCH PARSER","Summary":"更改一个文本检索解析器的定义","BodyHTML":"\u003cpre\u003eALTER TEXT SEARCH PARSER name RENAME TO new_name\nALTER TEXT SEARCH PARSER name SET SCHEMA new_schema\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eALTER TEXT SEARCH PARSER\u003c/code\u003e更改文本检索解析器的定义。当前唯一支持的功能是更改该解析器的名称。\u003c/p\u003e\u003cp\u003e要使用\u003ccode\u003eALTER TEXT SEARCH PARSER\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\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_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\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003eSQL 标准中没有\u003ccode\u003eALTER TEXT SEARCH PARSER\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-parser/?v=18\" title=\"CREATE TEXT SEARCH PARSER\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE TEXT SEARCH PARSER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-text-search-parser/?v=18\" title=\"DROP TEXT SEARCH PARSER\" rel=\"nofollow\"\u003e\u003cspan\u003eDROP TEXT SEARCH PARSER\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"b9af8f4a1e6a2512fe02f4517a5a76d5c313a370ec7f85a994c97ab13e724aa3","Payload":{"purpose_zh":"更改一个文本检索解析器的定义","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eALTER TEXT SEARCH PARSER\u003c/code\u003e更改文本检索解析器的定义。当前唯一支持的功能是更改该解析器的名称。\u003c/p\u003e\u003cp\u003e要使用\u003ccode class=\"command\"\u003eALTER TEXT SEARCH PARSER\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\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_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","key":"parameters","title":"参数"},{"html":"\u003cp\u003eSQL 标准中没有\u003ccode class=\"command\"\u003eALTER TEXT SEARCH PARSER\u003c/code\u003e语句。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-text-search-parser/?v=18\" title=\"CREATE TEXT SEARCH PARSER\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE TEXT SEARCH PARSER\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/drop-text-search-parser/?v=18\" title=\"DROP TEXT SEARCH PARSER\"\u003e\u003cspan class=\"refentrytitle\"\u003eDROP TEXT SEARCH PARSER\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"ALTER TEXT SEARCH PARSER \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 PARSER \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 PARSER name RENAME TO new_name\nALTER TEXT SEARCH PARSER 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}