I386LINUX/util/I386LINUX/doc/postgresql/html/sql-alterconversion.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >ALTER CONVERSION</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="SQL Commands"
  16 HREF="sql-commands.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="ALTER AGGREGATE"
  19 HREF="sql-alteraggregate.html"><LINK
  20 REL="NEXT"
  21 TITLE="ALTER DATABASE"
  22 HREF="sql-alterdatabase.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="REFENTRY"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="sql-alteraggregate.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="sql-alteraggregate.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 ></TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="sql-alterdatabase.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="sql-alterdatabase.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><H1
  91 ><A
  92 NAME="SQL-ALTERCONVERSION"
  93 ></A
  94 >ALTER CONVERSION</H1
  95 ><DIV
  96 CLASS="REFNAMEDIV"
  97 ><A
  98 NAME="AEN34653"
  99 ></A
 100 ><H2
 101 >Name</H2
 102 >ALTER CONVERSION&nbsp;--&nbsp;change the definition of a conversion</DIV
 103 ><A
 104 NAME="AEN34656"
 105 ></A
 106 ><DIV
 107 CLASS="REFSYNOPSISDIV"
 108 ><A
 109 NAME="AEN34658"
 110 ></A
 111 ><H2
 112 >Synopsis</H2
 113 ><PRE
 114 CLASS="SYNOPSIS"
 115 >ALTER CONVERSION <VAR
 116 CLASS="REPLACEABLE"
 117 >name</VAR
 118 > RENAME TO <VAR
 119 CLASS="REPLACEABLE"
 120 >newname</VAR
 121 ></PRE
 122 ></DIV
 123 ><DIV
 124 CLASS="REFSECT1"
 125 ><A
 126 NAME="AEN34662"
 127 ></A
 128 ><H2
 129 >Description</H2
 130 ><P
 131 >   <TT
 132 CLASS="COMMAND"
 133 >ALTER CONVERSION</TT
 134 > changes the definition of a
 135    conversion.  The only currently available functionality is to rename the
 136    conversion.
 137   </P
 138 ></DIV
 139 ><DIV
 140 CLASS="REFSECT1"
 141 ><A
 142 NAME="AEN34666"
 143 ></A
 144 ><H2
 145 >Parameters</H2
 146 ><P
 147 ></P
 148 ><DIV
 149 CLASS="VARIABLELIST"
 150 ><DL
 151 ><DT
 152 ><VAR
 153 CLASS="REPLACEABLE"
 154 >name</VAR
 155 ></DT
 156 ><DD
 157 ><P
 158 >      The name (optionally schema-qualified) of an existing conversion.
 159      </P
 160 ></DD
 161 ><DT
 162 ><VAR
 163 CLASS="REPLACEABLE"
 164 >newname</VAR
 165 ></DT
 166 ><DD
 167 ><P
 168 >      The new name of the conversion.
 169      </P
 170 ></DD
 171 ></DL
 172 ></DIV
 173 ></DIV
 174 ><DIV
 175 CLASS="REFSECT1"
 176 ><A
 177 NAME="AEN34679"
 178 ></A
 179 ><H2
 180 >Examples</H2
 181 ><P
 182 >   To rename the conversion <TT
 183 CLASS="LITERAL"
 184 >iso_8859_1_to_utf_8</TT
 185 > to
 186    <TT
 187 CLASS="LITERAL"
 188 >latin1_to_unicode</TT
 189 >:
 190 </P><PRE
 191 CLASS="PROGRAMLISTING"
 192 >ALTER CONVERSION iso_8859_1_to_utf_8 RENAME TO latin1_to_unicode;</PRE
 193 ><P>
 194   </P
 195 ></DIV
 196 ><DIV
 197 CLASS="REFSECT1"
 198 ><A
 199 NAME="AEN34685"
 200 ></A
 201 ><H2
 202 >Compatibility</H2
 203 ><P
 204 >   There is no <TT
 205 CLASS="COMMAND"
 206 >ALTER CONVERSION</TT
 207 > statement in the SQL
 208    standard.
 209   </P
 210 ></DIV
 211 ><DIV
 212 CLASS="REFSECT1"
 213 ><A
 214 NAME="AEN34689"
 215 ></A
 216 ><H2
 217 >See Also</H2
 218 ><A
 219 HREF="sql-createconversion.html"
 220 ><I
 221 >CREATE CONVERSION</I
 222 ></A
 223 >, <A
 224 HREF="sql-dropconversion.html"
 225 ><I
 226 >DROP CONVERSION</I
 227 ></A
 228 ></DIV
 229 ><DIV
 230 CLASS="NAVFOOTER"
 231 ><HR
 232 ALIGN="LEFT"
 233 WIDTH="100%"><TABLE
 234 SUMMARY="Footer navigation table"
 235 WIDTH="100%"
 236 BORDER="0"
 237 CELLPADDING="0"
 238 CELLSPACING="0"
 239 ><TR
 240 ><TD
 241 WIDTH="33%"
 242 ALIGN="left"
 243 VALIGN="top"
 244 ><A
 245 HREF="sql-alteraggregate.html"
 246 ACCESSKEY="P"
 247 >Prev</A
 248 ></TD
 249 ><TD
 250 WIDTH="34%"
 251 ALIGN="center"
 252 VALIGN="top"
 253 ><A
 254 HREF="index.html"
 255 ACCESSKEY="H"
 256 >Home</A
 257 ></TD
 258 ><TD
 259 WIDTH="33%"
 260 ALIGN="right"
 261 VALIGN="top"
 262 ><A
 263 HREF="sql-alterdatabase.html"
 264 ACCESSKEY="N"
 265 >Next</A
 266 ></TD
 267 ></TR
 268 ><TR
 269 ><TD
 270 WIDTH="33%"
 271 ALIGN="left"
 272 VALIGN="top"
 273 >ALTER AGGREGATE</TD
 274 ><TD
 275 WIDTH="34%"
 276 ALIGN="center"
 277 VALIGN="top"
 278 ><A
 279 HREF="sql-commands.html"
 280 ACCESSKEY="U"
 281 >Up</A
 282 ></TD
 283 ><TD
 284 WIDTH="33%"
 285 ALIGN="right"
 286 VALIGN="top"
 287 >ALTER DATABASE</TD
 288 ></TR
 289 ></TABLE
 290 ></DIV
 291 ></BODY
 292 ></HTML
 293 >