ALTER_TEXT_SEARCH_PARSER(7pg17)

💅 ALTER TEXT SEARCH PARSER 💅

okay bestie, real talk: this one's from the PostgreSQL 17 docs (the 7 manual, iykyk) and it's honestly a tiny little icon of a command. no cap, it does like two things total and both of them are "give it a different name." slay.

---

✨ NAME ✨

ALTER_TEXT_SEARCH_PARSER — change the definition of a text search parser 🎀

---

🦋 SYNOPSIS 🦋

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

---

🌸 DESCRIPTION 🌸

ALTER TEXT SEARCH PARSER changes the definition of a text search parser. literally that's the whole vibe 💅

and like… currently, the only supported functionality is to change the parser's name. that's it. that's the feature set. she's minimal but she's iconic.

⚠️ heads up bestie: you must be a superuser to use ALTER TEXT SEARCH PARSER. no superuser, no slay. it's giving exclusive.

---

🎀 PARAMETERS 🎀

• name — the name (optionally schema-qualified) of an existing text search parser. like, the one you're about to mess with 💖
• new_name — the new name of the text search parser. glow-up name, basically ✨
• new_schema — the new schema for the text search parser. moving her to a different neighborhood 🏡

---

🌈 COMPATIBILITY 🌈

there is no ALTER TEXT SEARCH PARSER statement in the SQL standard. not a single crumb. 🍓 so if you're out here looking for it in the standard, don't bother — it's not there, fr fr.

---

👑 SEE ALSO 👑

• CREATE TEXT SEARCH PARSER (CREATE_TEXT_SEARCH_PARSER(7))
• DROP TEXT SEARCH PARSER (DROP_TEXT_SEARCH_PARSER(7))

---

🫶 and that's the whole page, bestie. this masterpiece is PostgreSQL 17.11, dated 2026 — go forth and rename responsibly. periodt. 💜🧚‍♀️