ALTER_TEXT_SEARCH_TEMPLATE(7)

ALTER_TEXT_SEARCH_TEMPLATE7

Change the definition of a text search template

Usage

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

Overview

ALTER TEXT SEARCH TEMPLATE 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 ALTER TEXT SEARCH TEMPLATE.

Parameters

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.

Compatibility

There is no ALTER TEXT SEARCH TEMPLATE statement in the SQL standard.

From postgresql 18.6-4 in Arch Linux 2026-11-01. Parsed by carta from the page's man source.