1<!-- 2doc/src/sgml/ref/alter_language.sgml 3PostgreSQL documentation 4--> 5 6<refentry id="SQL-ALTERLANGUAGE"> 7 <indexterm zone="sql-alterlanguage"> 8 <primary>ALTER LANGUAGE</primary> 9 </indexterm> 10 11 <refmeta> 12 <refentrytitle>ALTER LANGUAGE</refentrytitle> 13 <manvolnum>7</manvolnum> 14 <refmiscinfo>SQL - Language Statements</refmiscinfo> 15 </refmeta> 16 17 <refnamediv> 18 <refname>ALTER LANGUAGE</refname> 19 <refpurpose>change the definition of a procedural language</refpurpose> 20 </refnamediv> 21 22 <refsynopsisdiv> 23<synopsis> 24ALTER [ PROCEDURAL ] LANGUAGE <replaceable>name</replaceable> RENAME TO <replaceable>new_name</replaceable> 25ALTER [ PROCEDURAL ] LANGUAGE <replaceable>name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER } 26</synopsis> 27 </refsynopsisdiv> 28 29 <refsect1> 30 <title>Description</title> 31 32 <para> 33 <command>ALTER LANGUAGE</command> changes the definition of a 34 procedural language. The only functionality is to rename the language or 35 assign a new owner. You must be superuser or owner of the language to 36 use <command>ALTER LANGUAGE</command>. 37 </para> 38 </refsect1> 39 40 <refsect1> 41 <title>Parameters</title> 42 43 <variablelist> 44 <varlistentry> 45 <term><replaceable>name</replaceable></term> 46 <listitem> 47 <para> 48 Name of a language 49 </para> 50 </listitem> 51 </varlistentry> 52 53 <varlistentry> 54 <term><replaceable>new_name</replaceable></term> 55 <listitem> 56 <para> 57 The new name of the language 58 </para> 59 </listitem> 60 </varlistentry> 61 62 <varlistentry> 63 <term><replaceable>new_owner</replaceable></term> 64 <listitem> 65 <para> 66 The new owner of the language 67 </para> 68 </listitem> 69 </varlistentry> 70 </variablelist> 71 </refsect1> 72 73 <refsect1> 74 <title>Compatibility</title> 75 76 <para> 77 There is no <command>ALTER LANGUAGE</command> statement in the SQL 78 standard. 79 </para> 80 </refsect1> 81 82 <refsect1> 83 <title>See Also</title> 84 85 <simplelist type="inline"> 86 <member><xref linkend="sql-createlanguage"></member> 87 <member><xref linkend="sql-droplanguage"></member> 88 </simplelist> 89 </refsect1> 90 91</refentry> 92