ALTER_LANGUAGE(7pg13)

✨ NAME ✨

okay so bestie, welcome to the ALTER LANGUAGE page from the PostgreSQL 13.23 Documentation — yes, that’s the manual name, it’s literally right there in the group chat 🫶 This one is all about changing the definition of a procedural language. slay.

🌸 SYNOPSIS 🌸

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

💖 DESCRIPTION 💖

ALTER LANGUAGE changes the definition of a procedural language. like, it is not doing a million things: the only functionality is to rename the language or assign a new owner. that’s it, that’s the main character energy 💅

permission check, no cap: you must be superuser or owner of the language to use ALTER LANGUAGE.

🎀 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. so if you’re looking for it in the standard, bestie, it’s not there 😭

🦋 SEE ALSO 🦋

• CREATE LANGUAGE (CREATE_LANGUAGE(7)) — the origin story 💖
• DROP LANGUAGE (DROP_LANGUAGE(7)) — the goodbye era 💀

sign-off era: this page is from PostgreSQL 13.23, dated 2025. mwah 💜