ALTER_TEXT_SEARCH_TEMPLATE(7pg17)

💖 NAME 💖

okay so this is the ALTER_TEXT_SEARCH_TEMPLATE(7pg17) page — officially the ALTER TEXT SEARCH TEMPLATE(7) manual page. The command is ALTER_TEXT_SEARCH_TEMPLATE, and it changes the definition of a text search template. That's the whole NAME-section tea. 🍵✨

🎀 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 what the page says, bestie — we keep every detail, no editing the lore.

🚨 superuser check: You must be a superuser to use ALTER TEXT SEARCH TEMPLATE. No cap, no side door mentioned here.

🌸 PARAMETERS 🌸

• name — the name of an existing text search template; it's optionally schema-qualified.
• 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. That's the compatibility note, periodt. 💅

🫶 SEE ALSO 🫶

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

mwah 💋 this iconic page is from PostgreSQL 17.11, dated 2026, and it's the ALTER TEXT SEARCH TEMPLATE(7) page. Byeee, go be your superuser main character self 🫶🎀