doc/src/sgml/ref/alter_language.sgml

   1 <!--
   2 $PostgreSQL$
   3 PostgreSQL documentation
   4 -->
   5
   6 <refentry id="SQL-ALTERLANGUAGE">
   7  <refmeta>
   8   <refentrytitle id="SQL-ALTERLANGUAGE-title">ALTER LANGUAGE</refentrytitle>
   9   <manvolnum>7</manvolnum>
  10   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  11  </refmeta>
  12
  13  <refnamediv>
  14   <refname>ALTER LANGUAGE</refname>
  15   <refpurpose>change the definition of a procedural language</refpurpose>
  16  </refnamediv>
  17
  18  <indexterm zone="sql-alterlanguage">
  19   <primary>ALTER LANGUAGE</primary>
  20  </indexterm>
  21
  22  <refsynopsisdiv>
  23 <synopsis>
  24 ALTER [ PROCEDURAL ] LANGUAGE <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable>
  25 ALTER [ PROCEDURAL ] LANGUAGE <replaceable>name</replaceable> OWNER TO <replaceable>new_owner</replaceable>
  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>newname</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" endterm="sql-createlanguage-title"></member>
  87    <member><xref linkend="sql-droplanguage" endterm="sql-droplanguage-title"></member>
  88   </simplelist>
  89  </refsect1>
  90
  91 </refentry>