ALTER_LANGUAGE(7pg17)

💅 ALTER LANGUAGE(7) 💅

okay bestie, welcome to the PostgreSQL 17.11 Documentation page for ALTER LANGUAGE(7) 💖 this one is short and sweet, and it is literally all about changing a procedural language’s definition. no cap.

✨ NAME ✨

ALTER_LANGUAGE — change the definition of a procedural language 🎀

🌸 SYNOPSIS 🌸

ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name
ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }

💅 DESCRIPTION 💅

okay so ALTER LANGUAGE changes the definition of a procedural language. the only functionality is to rename the language or assign a new owner. that’s it, that’s the whole vibe ✨

you must be superuser or owner of the language to use ALTER LANGUAGE — like, fr fr, no exceptions mentioned here 💀

🎀 PARAMETERS 🎀

• name — name of a language 🦋
• new_name — the new name of the language 💖
• new_owner — the new owner of the language 👑

🦋 COMPATIBILITY 🦋

there is no ALTER LANGUAGE statement in the SQL standard. not a thing. periodt. 🙈

🔥 SEE ALSO 🔥

• CREATE LANGUAGE (CREATE_LANGUAGE(7)) 🌈
• DROP LANGUAGE (DROP_LANGUAGE(7)) ⭐

xoxo, bestie 🫶 this was the PostgreSQL 17.11 version, dated 2026 — stay iconic and keep those languages renamed and re-owned 💜🎀