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