ALTER_LANGUAGE(7pg15)

🌸 NAME 🌸

ALTER_LANGUAGE — change the definition of a procedural language. this is the ALTER LANGUAGE(7pg15) page from the PostgreSQL 15.19 Documentation, bestie 💖.

✨ 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. that's the whole vibe. the only functionality is to rename the language or assign a new owner — no secret extra menu, no hidden features, periodt ✨.

you must be superuser or owner of the language to use ALTER LANGUAGE. so yeah, permissions check first, bestie 🫶.

🎀 PARAMETERS 🎀

• name — name of a language. iconic identifier energy 💅.
• new_name — the new name of the language. glow-up name, literally 🌟.
• new_owner — the new owner of the language. hand over the keys 👑.

🌈 COMPATIBILITY 🌈

there is no ALTER LANGUAGE statement in the SQL standard. not a thing. the standard said “who?” 💀.

🦋 SEE ALSO 🦋

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

mwah 💋 — from PostgreSQL 15.19, dated 2026, page ALTER LANGUAGE(7). that's the whole page, ily bye! 🎀