---
title: "ALTER TEXT SEARCH TEMPLATE"
id: sql-altertstemplate
pg_version: "20devel"
---

<a id="sql-altertstemplate"></a>

# 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
```

<a id="id-1.9.3.41.5"></a>

## 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`. 

<a id="id-1.9.3.41.6"></a>

## 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. <a id="id-1.9.3.41.7"></a>

## Compatibility

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

<a id="id-1.9.3.41.8"></a>

## See Also

[CREATE TEXT SEARCH TEMPLATE](sql-createtstemplate.md), [DROP TEXT SEARCH TEMPLATE](sql-droptstemplate.md)