ALTER_TEXT_SEARCH_TEMPLATE(7pg16)

✨ NAME ✨

okay so this is ALTER_TEXT_SEARCH_TEMPLATE — the page that changes the definition of a text search template — straight from the PostgreSQL 16.15 Documentation. We’re on the ALTER_TEXT_SEARCH_TEMPLATE(7pg16) beat, bestie 💅✨

💖 SYNOPSIS 💖

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

No cap, that’s the whole shape of it 🎀

🦋 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 the tea ☕️

🚨 bestie warning: you must be a superuser to use ALTER TEXT SEARCH TEMPLATE. Like, actually. superuser only, periodt.

🌸 PARAMETERS 🌸

• name — the name (optionally schema-qualified) of an existing text search template. It’s giving “tell me exactly which one” 💁‍♀️
• new_name — the new name of the text search template. The rebrand, the glow-up, the new era ✨
• new_schema — the new schema for the text search template. Moving it to a different schema neighborhood 🏡

🌈 COMPATIBILITY 🌈

There is no ALTER TEXT SEARCH TEMPLATE statement in the SQL standard. Not a thing. The SQL standard simply did not include this one, iykyk 💀

👑 SEE ALSO 👑

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

okay bestie, cute little sign-off time 🫶 this page is from the PostgreSQL 16.15 Documentation, with the footer energy saying PostgreSQL 16.15 and dated 2026 — ALTER TEX... TEMPLATE(7) and all that 💖🎀💅