2
$PostgreSQL: pgsql/doc/src/sgml/ref/alter_conversion.sgml,v 1.5 2004-06-25 21:55:50 tgl Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-ALTERCONVERSION">
8
<refentrytitle id="SQL-ALTERCONVERSION-TITLE">ALTER CONVERSION</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>ALTER CONVERSION</refname>
14
<refpurpose>change the definition of a conversion</refpurpose>
17
<indexterm zone="sql-alterconversion">
18
<primary>ALTER CONVERSION</primary>
23
ALTER CONVERSION <replaceable>name</replaceable> RENAME TO <replaceable>newname</replaceable>
24
ALTER CONVERSION <replaceable>name</replaceable> OWNER TO <replaceable>newowner</replaceable>
29
<title>Description</title>
32
<command>ALTER CONVERSION</command> changes the definition of a
38
<title>Parameters</title>
42
<term><replaceable class="parameter">name</replaceable></term>
45
The name (optionally schema-qualified) of an existing conversion.
51
<term><replaceable class="parameter">newname</replaceable></term>
54
The new name of the conversion.
60
<term><replaceable class="parameter">newowner</replaceable></term>
63
The new owner of the conversion. To change the owner of a conversion,
64
you must be a superuser.
72
<title>Examples</title>
75
To rename the conversion <literal>iso_8859_1_to_utf_8</literal> to
76
<literal>latin1_to_unicode</literal>:
78
ALTER CONVERSION iso_8859_1_to_utf_8 RENAME TO latin1_to_unicode;
83
To change the owner of the conversion <literal>iso_8859_1_to_utf_8</literal> to
84
<literal>joe</literal>:
86
ALTER CONVERSION iso_8859_1_to_utf_8 OWNER TO joe;
92
<title>Compatibility</title>
95
There is no <command>ALTER CONVERSION</command> statement in the SQL
101
<title>See Also</title>
103
<simplelist type="inline">
104
<member><xref linkend="sql-createconversion" endterm="sql-createconversion-title"></member>
105
<member><xref linkend="sql-dropconversion" endterm="sql-dropconversion-title"></member>
110
<!-- Keep this comment at the end of the file
115
sgml-minimize-attributes:nil
116
sgml-always-quote-attributes:t
119
sgml-parent-document:nil
120
sgml-default-dtd-file:"../reference.ced"
121
sgml-exposed-tags:nil
122
sgml-local-catalogs:"/usr/lib/sgml/catalog"
123
sgml-local-ecat-files:nil