ALTER_TEXT_SEARCH_TEMPLATE(7)

💖 ALTER TEXT SEARCH TEMPLATE 💖

okay so bestie, this is a page from the PostgreSQL 18.6 Documentation and it's all about the ALTER TEXT SEARCH TEMPLATE command. it's short, it's sweet, it's giving "lowkey one-job wonder" and honestly? we respect it. ✨

---

🌸 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 ✨

So like, ALTER TEXT SEARCH TEMPLATE changes the definition of a text search template. iconic behaviour, truly.

but here's the tea: right now, the only supported functionality is to change the template's name. that's it. that's the whole menu. no cap. 🫶

⚠️ bestie listen — you must be a superuser to use ALTER TEXT SEARCH TEMPLATE. this is not a drill, this is not a vibe check you can skip. if you're not a superuser, this command is not your moment. 💀

---

💅 PARAMETERS 💅

• name — the name of an existing text search template. it can be schema-qualified if you want to be extra specific, which is valid and also kind of main character energy. 👑
• new_name — the new name of the text search template. like a glow-up but for identifiers. ✨
• new_schema — the new schema for the text search template. moving it to a different neighbourhood. 🦋

---

🌈 COMPATIBILITY 🌈

ngl, there is no ALTER TEXT SEARCH TEMPLATE statement in the SQL standard. so if you're out here looking for it in the spec... it's not there. fr fr. it's a PostgreSQL original, and that's just the way it is. 💅

---

👀 SEE ALSO 👀

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

go read those too, they're part of the squad. 🌸

---

and that's the whole page, bestie!! this was brought to you by PostgreSQL 18.6, dated 2026 — mwah, take care of your templates, don't forget your superuser powers, and stan a short manpage. 💖🎀🦋✨