ALTER_TEXT_SEARCH_TEMPLATE(7pg13)

💅 ALTER TEXT SEARCH TEMPLATE — the glow-up page (7pg13)

okay so bestie, welcome to the ALTER TEXT SEARCH TEMPLATE manual page, from the PostgreSQL 13.23 docs. yes the real title got chopped into ALTER TEX... TEMPLATE(7) up in the header because man page headers have zero chill about column width, but you and me? we know the full name. 🎀

---

✨ NAME ✨

ALTER_TEXT_SEARCH_TEMPLATE — change the definition of a text search template. that's it. that's the whole vibe. 💖

---

🦋 SYNOPSIS 🦋

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

two moves. two icons. pick your fighter. 👑

---

🌸 DESCRIPTION 🌸

so ALTER TEXT SEARCH TEMPLATE changes the definition of a text search template. and like, "changes the definition" sounds all dramatic and main-character, but rn the only supported functionality is to change the template's name. that's it. that's the entire menu. no cap. 🫶

⚠️ real talk: you must be a superuser to use ALTER TEXT SEARCH TEMPLATE. not optional. not negotiable. if you're not a superuser, the vibe check fails, and honestly? that's on you for not having the perms.

---

🎀 PARAMETERS 🎀

• name — the name (optionally schema-qualified) of an existing text search template. the whole "optionally schema-qualified" thing is doing a lot of heavy lifting here — it means you can say where it lives if you need to. lowkey useful. ✨
• new_name — the new name of the text search template. this is the rebrand. the rename. the "new year new me." 💅
• new_schema — the new schema for the text search template. moving house, template edition. 🏠

---

💀 COMPATIBILITY 💀

there is no ALTER TEXT SEARCH TEMPLATE statement in the SQL standard. none. doesn't exist. so if you're out here expecting standard-compliance points for this one, bestie… no. 🙈 this is a PostgreSQL-original situation. iykyk.

---

🌈 SEE ALSO 🌈

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

like the whole template saga — make it, rename it, drop it. character arc complete. 🔥

---

okay that's the page!! mwah!! 💜 this absolute icon of a manpage came to you courtesy of PostgreSQL 13.23, dated 2025 — ALTER TEX... TEMPLATE(7) and out. 🍓🧚⭐