1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
5
>ALTER EXTENSION</TITLE
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="sql-commands.html"><LINK
19
HREF="sql-alterdomain.html"><LINK
21
TITLE="ALTER FOREIGN DATA WRAPPER"
22
HREF="sql-alterforeigndatawrapper.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="sql-alterdomain.html"
67
HREF="sql-alterdomain.html"
80
TITLE="ALTER FOREIGN DATA WRAPPER"
81
HREF="sql-alterforeigndatawrapper.html"
89
TITLE="ALTER FOREIGN DATA WRAPPER"
90
HREF="sql-alterforeigndatawrapper.html"
101
NAME="SQL-ALTEREXTENSION"
111
>ALTER EXTENSION -- change the definition of an extension
114
CLASS="REFSYNOPSISDIV"
220
FOREIGN DATA WRAPPER <TT
291
[ PROCEDURAL ] LANGUAGE <TT
321
TEXT SEARCH CONFIGURATION <TT
327
TEXT SEARCH DICTIONARY <TT
333
TEXT SEARCH PARSER <TT
339
TEXT SEARCH TEMPLATE <TT
369
> changes the definition of an installed
370
extension. There are several subforms:
384
> This form updates the extension to a newer version. The extension
385
must supply a suitable update script (or series of scripts) that can
386
modify the currently-installed version into the requested version.
396
> This form moves the extension's objects into another schema. The
397
extension has to be <I
400
> for this command to
416
> This form adds an existing object to the extension. This is mainly
417
useful in extension update scripts. The object will subsequently
418
be treated as a member of the extension; notably, it can only be
419
dropped by dropping the extension.
434
> This form removes a member object from the extension. This is mainly
435
useful in extension update scripts. The object is not dropped, only
436
disassociated from the extension.
444
HREF="extend-extensions.html"
446
> for more information about these
450
> You must own the extension to use <TT
460
> forms require ownership of the
461
added/dropped object as well.
486
> The name of an installed extension.
498
> The desired new version of the extension. This can be written as
499
either an identifier or a string literal. If not specified,
502
>ALTER EXTENSION UPDATE</TT
503
> attempts to update to whatever is
504
shown as the default version in the extension's control file.
516
> The new schema for the extension.
543
> The name of an object to be added to or removed from the extension.
545
aggregates, domains, foreign tables, functions, operators,
546
operator classes, operator families, sequences, text search objects,
547
types, and views can be schema-qualified.
559
> An input data type on which the aggregate function operates.
560
To reference a zero-argument aggregate function, write <TT
564
in place of the list of input data types.
576
> The name of the source data type of the cast.
588
> The name of the target data type of the cast.
600
> The mode of a function argument: <TT
614
If omitted, the default is <TT
621
> does not actually pay
625
> arguments, since only the input
626
arguments are needed to determine the function's identity.
627
So it is sufficient to list the <TT
649
> The name of a function argument.
653
> does not actually pay
654
any attention to argument names, since only the argument data
655
types are needed to determine the function's identity.
667
> The data type(s) of the function's arguments (optionally
668
schema-qualified), if any.
678
> This is a noise word.
697
> extension to version 2.0:
699
CLASS="PROGRAMLISTING"
700
>ALTER EXTENSION hstore UPDATE TO '2.0';</PRE
704
> To change the schema of the <TT
713
CLASS="PROGRAMLISTING"
714
>ALTER EXTENSION hstore SET SCHEMA utils;</PRE
718
> To add an existing function to the <TT
723
CLASS="PROGRAMLISTING"
724
>ALTER EXTENSION hstore ADD FUNCTION populate_record(anyelement, hstore);</PRE
731
NAME="SQL-ALTEREXTENSION-SEE-ALSO"
736
HREF="sql-createextension.html"
739
HREF="sql-dropextension.html"
747
SUMMARY="Footer navigation table"
758
HREF="sql-alterdomain.html"
776
HREF="sql-alterforeigndatawrapper.html"
792
HREF="sql-commands.html"
800
>ALTER FOREIGN DATA WRAPPER</TD
b'\\ No newline at end of file'