ALTER LANGUAGE(7) PostgreSQL 16.3 Documentation ALTER LANGUAGE(7)

ALTER_LANGUAGE - change the definition of a procedural language

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

ALTER LANGUAGE changes the definition of a procedural language. The only functionality is to rename the language or assign a new owner. You must be superuser or owner of the language to use ALTER LANGUAGE.

name

Name of a language

new_name

The new name of the language

new_owner

The new owner of the language

There is no ALTER LANGUAGE statement in the SQL standard.

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

2024 PostgreSQL 16.3