DROP_TEXT_SEARCH_DICTIONARY(7pg16)

hii bestie 💖 this is the DROP TEXT SEARCH DICTIONARY manual page — manual name DROP TEX...ICTIONARY(7), and if your tab says DROP_TEXT_SEARCH_DICTIONARY(7pg16), yep, same page, you're in the right place 🫶

🌸 NAME 🌸

DROP_TEXT_SEARCH_DICTIONARY — remove a text search dictionary ✨

✨ SYNOPSIS ✨

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

💅 DESCRIPTION 💅

okay so DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. To execute this command you must be the owner of the dictionary. Like, owner energy only 👑.

🎀 PARAMETERS 🎀

• IF EXISTS — do not throw an error if the text search dictionary does not exist. A notice is issued in this case. Graceful missing-dictionary moment, we love to see it 🌸.
• name — the name (optionally schema-qualified) of an existing text search dictionary. Yes, schema-qualified is allowed, iykyk ✨.
• CASCADE — automatically drop objects that depend on the text search dictionary, and in turn all objects that depend on those objects (see Section 5.14). Chain-reaction slay 🔥.
• RESTRICT — refuse to drop the text search dictionary if any objects depend on it. This is the default. Safety-girlie default behavior 💅.

🦋 EXAMPLES 🦋

Remove the text search dictionary english:

DROP TEXT SEARCH DICTIONARY english;

This command will not succeed if there are any existing text search configurations that use the dictionary. Add CASCADE to drop such configurations along with the dictionary.

🌈 COMPATIBILITY 🌈

There is no DROP TEXT SEARCH DICTIONARY statement in the SQL standard. The SQL standard is literally not giving this statement, periodt 🙈.

🔥 SEE ALSO 🔥

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

---

mwah 💋 that's the whole page — source/version: PostgreSQL 16.15 documentation, date: 2026, manual tag: DROP TEX...ICTIONARY(7). byeee bestie, go drop (or not drop) responsibly 🫶✨