ALTER LANGUAGE
change the definition of a procedural language
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-ALTERLANGUAGE
- file
- sql-alterlanguage.html
- lang
- en
- name
- ALTER LANGUAGE
- purpose
- change the definition of a procedural language
- purpose zh
- 更改一种过程语言的定义
- sections same as
- Unknown
- slug
- 18
- synopsis text
- ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
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
Definition PG 18
ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name
ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }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
nameName of a language
new_nameThe new name of the language
new_ownerThe new owner of the language
Compatibility
There is no ALTER LANGUAGE statement in the SQL standard.
See Also
CREATE LANGUAGE, DROP LANGUAGECompare versions
Complete source facts
synopsis html
ALTER [ PROCEDURAL ] LANGUAGE <em class="replaceable"><code>name</code></em> RENAME TO <em class="replaceable"><code>new_name</code></em>
ALTER [ PROCEDURAL ] LANGUAGE <em class="replaceable"><code>name</code></em> OWNER TO { <em class="replaceable"><code>new_owner</code></em> | CURRENT_ROLE | CURRENT_USER | SESSION_USER }Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:a4f2be650a1ec8cbae4cdeb8baee2c174a74ddc1e222b40438d3cb45ad398f56
Text language: en · wiki-repair-20261023:a4f2be650a1ec8cbae4cdeb8baee2c174a74ddc1e222b40438d3cb45ad398f56