Change the definition of an extension that is registered in a Greenplum database.
ALTER EXTENSION <name> UPDATE [ TO <new_version> ]
ALTER EXTENSION <name> SET SCHEMA <new_schema>
ALTER EXTENSION <name> ADD <member_object>
ALTER EXTENSION <name> DROP <member_object>
where <member_object> is:
ACCESS METHOD <object_name> |
AGGREGATE <aggregate_name> ( <aggregate_signature> ) |
CAST (<source_type> AS <target_type>) |
COLLATION <object_name> |
CONVERSION <object_name> |
DOMAIN <object_name> |
EVENT TRIGGER <object_name> |
FOREIGN DATA WRAPPER <object_name> |
FOREIGN TABLE <object_name> |
FUNCTION <function_name> ( [ [ <argmode> ] [ <argname> ] <argtype> [, ...] ] ) |
MATERIALIZED VIEW <object_name> |
OPERATOR <operator_name> (<left_type>, <right_type>) |
OPERATOR CLASS <object_name> USING <index_method> |
OPERATOR FAMILY <object_name> USING <index_method> |
[ PROCEDURAL ] LANGUAGE <object_name> |
SCHEMA <object_name> |
SEQUENCE <object_name> |
SERVER <object_name> |
TABLE <object_name> |
TEXT SEARCH CONFIGURATION <object_name> |
TEXT SEARCH DICTIONARY <object_name> |
TEXT SEARCH PARSER <object_name> |
TEXT SEARCH TEMPLATE <object_name> |
TRANSFORM FOR <type_name> LANGUAGE <lang_name> |
TYPE <object_name> |
VIEW <object_name>
and <aggregate_signature> is:
* | [ <argmode> ] [ <argname> ] <argtype> [ , ... ] |
[ [ <argmode> ] [ <argname> ] <argtype> [ , ... ] ]
ORDER BY [ <argmode> ] [ <argname> ] <argtype> [ , ... ]
ALTER EXTENSION
changes the definition of an installed extension. These are the subforms:
See Packaging Related Objects into an Extension for more information about these operations.
You must own the extension to use ALTER EXTENSION
. The ADD
and DROP
forms also require ownership of the object that is being added or dropped.
The mode of a function or aggregate argument: IN
, OUT
, INOUT
, or VARIADIC
. The default is IN
.
The command ignores the OUT
arguments. Only the input arguments are required to determine the function identity. It is sufficient to list the IN
, INOUT
, and VARIADIC
arguments.
The name of a function or aggregate argument.
The command ignores argument names, since only the argument data types are required to determine the function identity.
NONE
for the missing argument of a prefix or postfix operator.
To update the hstore extension to version 2.0:
ALTER EXTENSION hstore UPDATE TO '2.0';
To change the schema of the hstore
extension to utils
:
ALTER EXTENSION hstore SET SCHEMA utils;
To add an existing function to the hstore
extension:
ALTER EXTENSION hstore ADD FUNCTION populate_record(anyelement, hstore);
ALTER EXTENSION
is a Greenplum Database extension.
CREATE EXTENSION, DROP EXTENSION
Parent topic: SQL Command Reference