---
name: "ALTER_TEXT_SEARCH_TEMPLATE"
section: "7"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/ALTER_TEXT_SEARCH_TEMPLATE"
---

# ALTER\_TEXT\_SEARCH\_TEMPLATE(7)

change the definition of a text search template

## NAME

ALTER\_TEXT\_SEARCH\_TEMPLATE - change the definition of a text search template

## SYNOPSIS

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

## DESCRIPTION

**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.

## SEE ALSO

CREATE TEXT SEARCH TEMPLATE ([**CREATE\_TEXT\_SEARCH\_TEMPLATE**(7)](/CREATE_TEXT_SEARCH_TEMPLATE/7.md)), DROP TEXT SEARCH TEMPLATE ([**DROP\_TEXT\_SEARCH\_TEMPLATE**(7)](/DROP_TEXT_SEARCH_TEMPLATE/7.md))