ALTER TEXT SEARCH TEMPLATE — change the definition of a text search template
| Use Case | Command | Description |
|---|---|---|
| Rename a template | ALTER TEXT SEARCH TEMPLATE old_name RENAME TO new_name; |
Assign a new name to the text search template |
| Move to another schema | ALTER TEXT SEARCH TEMPLATE name SET SCHEMA new_schema; |
Relocate the template to a different schema |
ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name
ALTER TEXT SEARCH TEMPLATE name SET SCHEMA new_schema
📌 Replace name, new_name, and new_schema with actual values.
ALTER TEXT SEARCH TEMPLATE changes the definition of a text search template. Currently, the only supported functionality is to change the template's name and schema.
🔐 You must be a superuser to use ALTER TEXT SEARCH TEMPLATE.
name — The name (optionally schema-qualified) of an existing text search template.new_name — The new name of the text search template.new_schema — The new schema for the text search template.📜 There is no ALTER TEXT SEARCH TEMPLATE statement in the SQL standard.
Generated by phpman v4.9.22-1-g1b0fcb4 · Markdown · JSON · MCP Author: Che Dong Under GNU General Public License
2026-07-05 06:46 @216.73.216.52
CrawledBy Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Enhanced by LLM: deepseek-v4-pro / taotoken.net / www.chedong.com - original format