ALTER_TEXT_SEARCH_TEMPLATE - change the definition of a text search template

There is no ALTERTEXTSEARCHTEMPLATE statement in the SQL standard.

ALTERTEXTSEARCHTEMPLATE changes the definition of a text search template. Currently, the only supported functionality is to change the template's name. You must be a superuser to use ALTERTEXTSEARCHTEMPLATE.

ALTER_TEXT_SEARCH_TEMPLATE - change the definition of a 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.

CREATE TEXT SEARCH TEMPLATE (CREATE_TEXT_SEARCH_TEMPLATE(7)), DROP TEXT SEARCH TEMPLATE (DROP_TEXT_SEARCH_TEMPLATE(7)) PostgreSQL 17.5 2025 ALTERTEXTSEARCHTEMPLATE(7)

ALTER TEXT SEARCH TEMPLATE name RENAME TO new_name ALTER TEXT SEARCH TEMPLATE name SET SCHEMA new_schema