SQL Commands / Functions & Procedures

ALTER LANGUAGE

change the definition of a procedural language

Reading PG 18current·documented in 24 of 30 versions, 7.4 to 20

6.4 6.5 7.0 7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Syntax

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

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

ALTER LANGUAGE · Syntax 2

Description

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.

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.

Related entries

CREATE LANGUAGE DROP LANGUAGE

Definition snapshot: b7bd9cda · English manual source