DROP_TEXT_SEARCH_DICTIONARY(7)

💅 DROP TEXT SEARCH DICTIONARY 💅

okay bestie, gather round, because we're talking about DROP TEXT SEARCH DICTIONARY from the PostgreSQL 18.6 Documentation — this is the manual page DROP_TEXT_SEARCH_DICTIONARY(7) and she is iconic in a very specific, very niche way. let's get into it ✨

---

✨ NAME ✨

DROP_TEXT_SEARCH_DICTIONARY — remove a text search dictionary 🗑️💖

no literally that's the whole vibe. we're deleting a dictionary. a text search one. bye babe 👋

---

🎀 SYNOPSIS 🎀

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

look at her. short. sweet. dangerous. main character energy fr fr 🫶

---

🌸 DESCRIPTION 🌸

DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. that's it, that's the plot 💀

but listen — to actually run this command you must be the owner of the dictionary. not a friend of the owner, not someone who once liked the owner's post. the owner. periodt 👑

---

💖 PARAMETERS 💖

• IF EXISTS — do not throw an error if the text search dictionary doesn't exist. instead, a notice gets issued in this case. so like, no drama, just a lil heads up 🫶. it's giving "we're not mad, we're just disappointed" energy.
• name — the name (optionally schema-qualified) of an existing text search dictionary. yeah, you can schema-qualify it, she's flexible like that 💅.
• CASCADE — automatically drop objects that depend on the text search dictionary, and in turn all objects that depend on those objects (see Section 5.15). it's a whole chain reaction bestie, dominoes but make it SQL 🔥.
• RESTRICT — refuse to drop the text search dictionary if any objects depend on it. this is the default, so if you don't say anything, she's gonna be cautious. boundaries ✋💖.

---

🦋 EXAMPLES 🦋

wanna remove the text search dictionary english? say less:

DROP TEXT SEARCH DICTIONARY english;

heads up though 🚨 — this command will not succeed if there are any existing text search configurations that use the dictionary. she's got dependents, she can't just vanish.

if you wanna go full send, add CASCADE to drop such configurations along with the dictionary:

DROP TEXT SEARCH DICTIONARY english CASCADE;

ngl that one's giving a lil unhinged but sometimes you gotta do what you gotta do 😭

---

🌈 COMPATIBILITY 🌈

plot twist: there is no DROP TEXT SEARCH DICTIONARY statement in the SQL standard. so this is pure PostgreSQL original flavor, no cap 💀✨

---

💜 SEE ALSO 💜

• ALTER TEXT SEARCH DICTIONARY (ALTER_TEXT_SEARCH_DICTIONARY(7))
• CREATE TEXT SEARCH DICTIONARY (CREATE_TEXT_SEARCH_DICTIONARY(7))

go read those too, they're the prequel and the sequel bestie, you can't skip them 🎀

---

and that's the whole page!! 🥳 this was PostgreSQL 18.6, dated 2026 — shoutout to the whole documentation team, absolute legends, we love them, we thank them 🫶💖 slay, stay safe, and always check your dependencies before you drop anything. mwah 💅✨