DROP_TEXT_SEARCH_TEMPLATE(7pg15)

💅 DROP_TEXT_SEARCH_TEMPLATE(7pg15) 💅

okay bestie, welcome to the manual page for DROP_TEXT_SEARCH_TEMPLATE — we’re removing a text search template today, and the vibe is very “bye, template, you’re not the main character anymore.” ✨

---

🎀 NAME 🎀

DROP_TEXT_SEARCH_TEMPLATE — remove a text search template. That’s it, that’s the whole errand. 💖

🪄 SYNOPSIS 🪄

DROP TEXT SEARCH TEMPLATE [ IF EXISTS ] name [ CASCADE | RESTRICT ]

🌸 DESCRIPTION 🌸

okay so DROP TEXT SEARCH TEMPLATE drops an existing text search template. literally its whole job. 🫶

bestie, you must be a superuser to use this command. no cap, it’s superuser-only. 🔥

✨ PARAMETERS ✨

• IF EXISTS — do not throw an error if the text search template does not exist. a notice is issued in this case. so it’s like, “okay, it wasn’t there, noted” 💅
• name — the name (optionally schema-qualified) of an existing text search template. 🎀
• CASCADE — automatically drop objects that depend on the text search template, and in turn all objects that depend on those objects (see Section 5.14). it’s giving chain-reaction energy. 💥
• RESTRICT — refuse to drop the text search template if any objects depend on it. this is the default. 🛑✨

🧚 EXAMPLES 🧚

remove the text search template thesaurus:

DROP TEXT SEARCH TEMPLATE thesaurus;

this command will not succeed if there are any existing text search dictionaries that use the template. add CASCADE to drop such dictionaries along with the template. 😭👑

💀 COMPATIBILITY 💀

there is no DROP TEXT SEARCH TEMPLATE statement in the SQL standard. fr fr, standard said “not me.” 🙈

👑 SEE ALSO 👑

• ALTER TEXT SEARCH TEMPLATE (ALTER_TEXT_SEARCH_TEMPLATE(7)) — for when you want to alter instead of drop. 💜
• CREATE TEXT SEARCH TEMPLATE (CREATE_TEXT_SEARCH_TEMPLATE(7)) — for when you want to create instead. 🌈

---

💖 that’s the tea, bestie: this page is from the PostgreSQL 15.19 documentation, dated 2026. mwah, go drop that template (responsibly). 🎀✨