doc/src/sgml/ref/alter_conversion.sgml

   1 <!--
   2 $PostgreSQL$
   3 PostgreSQL documentation
   4 -->
   5
   6 <refentry id="SQL-ALTERCONVERSION">
   7  <refmeta>
   8   <refentrytitle id="SQL-ALTERCONVERSION-TITLE">ALTER CONVERSION</refentrytitle>
   9   <manvolnum>7</manvolnum>
  10   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  11  </refmeta>
  12
  13  <refnamediv>
  14   <refname>ALTER CONVERSION</refname>
  15   <refpurpose>change the definition of a conversion</refpurpose>
  16  </refnamediv>
  17
  18  <indexterm zone="sql-alterconversion">
  19   <primary>ALTER CONVERSION</primary>
  20  </indexterm>
  21
  22  <refsynopsisdiv>
  23 <synopsis>
  24 ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable>
  25 ALTER CONVERSION <replaceable>name</replaceable> OWNER TO <replaceable>newowner</replaceable>
  26 </synopsis>
  27  </refsynopsisdiv>
  28
  29  <refsect1>
  30   <title>Description</title>
  31
  32   <para>
  33    <command>ALTER CONVERSION</command> changes the definition of a
  34    conversion.
  35   </para>
  36
  37   <para>
  38    You must own the conversion to use <command>ALTER CONVERSION</>.
  39    To alter the owner, you must also be a direct or indirect member of the new
  40    owning role, and that role must have <literal>CREATE</literal> privilege on
  41    the conversion's schema.  (These restrictions enforce that altering the
  42    owner doesn't do anything you couldn't do by dropping and recreating the
  43    conversion. However, a superuser can alter ownership of any conversion
  44    anyway.)
  45   </para>
  46  </refsect1>
  47
  48  <refsect1>
  49   <title>Parameters</title>
  50
  51   <variablelist>
  52    <varlistentry>
  53     <term><replaceable class="parameter">name</replaceable></term>
  54     <listitem>
  55      <para>
  56       The name (optionally schema-qualified) of an existing conversion.
  57      </para>
  58     </listitem>
  59    </varlistentry>
  60
  61    <varlistentry>
  62     <term><replaceable class="parameter">newname</replaceable></term>
  63     <listitem>
  64      <para>
  65       The new name of the conversion.
  66      </para>
  67     </listitem>
  68    </varlistentry>
  69
  70    <varlistentry>
  71     <term><replaceable class="parameter">newowner</replaceable></term>
  72     <listitem>
  73      <para>
  74       The new owner of the conversion.
  75      </para>
  76     </listitem>
  77    </varlistentry>
  78   </variablelist>
  79  </refsect1>
  80
  81  <refsect1>
  82   <title>Examples</title>
  83
  84   <para>
  85    To rename the conversion <literal>iso_8859_1_to_utf8</literal> to
  86    <literal>latin1_to_unicode</literal>:
  87 <programlisting>
  88 ALTER CONVERSION iso_8859_1_to_utf8 RENAME TO latin1_to_unicode;
  89 </programlisting>
  90   </para>
  91
  92   <para>
  93    To change the owner of the conversion <literal>iso_8859_1_to_utf8</literal> to
  94    <literal>joe</literal>:
  95 <programlisting>
  96 ALTER CONVERSION iso_8859_1_to_utf8 OWNER TO joe;
  97 </programlisting>
  98   </para>
  99  </refsect1>
 100
 101  <refsect1>
 102   <title>Compatibility</title>
 103
 104   <para>
 105    There is no <command>ALTER CONVERSION</command> statement in the SQL
 106    standard.
 107   </para>
 108  </refsect1>
 109
 110  <refsect1>
 111   <title>See Also</title>
 112
 113   <simplelist type="inline">
 114    <member><xref linkend="sql-createconversion" endterm="sql-createconversion-title"></member>
 115    <member><xref linkend="sql-dropconversion" endterm="sql-dropconversion-title"></member>
 116   </simplelist>
 117  </refsect1>
 118 </refentry>