ALTER_TEXT_SEARCH_TEMPLATE(7pg15)

💖 NAME 💖

okay so this is the ALTER TEXT SEARCH TEMPLATE(7) page from the PostgreSQL 15.19 Documentation, and the main-character job is literally: ALTER_TEXT_SEARCH_TEMPLATE — change the definition of a text search template. That’s the vibe. 🦋

---

✨ SYNOPSIS ✨

Here’s the exact shape of it, bestie — copy these verbatim:

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. That’s it, that’s the tea. 🍓

⚠️ Important: you must be a superuser to use ALTER TEXT SEARCH TEMPLATE. No cap, this is not a drill. 💅

---

🎀 PARAMETERS 🎀

• name — the name (optionally schema-qualified) of an existing text search template. iykyk ✨
• 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 you’re looking for it in the standard, bestie, it’s giving absent. 😭

---

👑 SEE ALSO 👑

Go peek at these too:

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

---

🫶 cute lil sign-off: this page is from PostgreSQL 15.19, dated 2026. Slay, bye. 💖