ALTER_TEXT_SEARCH_TEMPLATE(7pg14)

💖 NAME 💖

okay bestie, welcome to ALTER_TEXT_SEARCH_TEMPLATE(7pg14) — the PostgreSQL 14.24 page for ALTER TEXT SEARCH TEMPLATE. This statement changes the definition of a text search template. It's lowkey giving "tiny admin command, big main character energy" ✨.

🌸 SYNOPSIS 🌸

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

🦋 DESCRIPTION 🦋

so ALTER TEXT SEARCH TEMPLATE changes the definition of a text search template. Currently, the only supported functionality is to change the template's name. That's it, that's the whole supported menu, bestie. 🎀

You must be a superuser to use ALTER TEXT SEARCH TEMPLATE. Not optional, no cap — superuser status is required.

🍓 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. So if someone asks, nope, it's not a standard SQL thing. 💀

👑 SEE ALSO 👑

• CREATE TEXT SEARCH TEMPLATE (CREATE_TEXT_SEARCH_TEMPLATE(7))
• DROP TEXT SEARCH TEMPLATE (DROP_TEXT_SEARCH_TEMPLATE(7))

mwah 💋 source/version: PostgreSQL 14.24; date: 2026; footer text: ALTER TEX... TEMPLATE(7). That's the whole page, bestie — periodt. 🫶