ALTER EXTENSION modifies the definition of an extension.
The syntax is only available in extended mode (when GUC parameter support_extended_features is on). Enable the mode with caution. It is used for tools like internal upgrade tools. Common users should not use the mode.
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;
FOREIGN TABLE object_name | FUNCTION function_name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) | [ PROCEDURAL ] LANGUAGE object_name | SCHEMA object_name | SERVER object_name | TABLE object_name | TEXT SEARCH CONFIGURATION object_name | TYPE object_name | VIEW object_name
Specifies the name of an extension.
Value range: A string indicating an existing extension.
Updates the extension to a new version.
Updates the extension to a new schema.
Adds an existing object to the extension.
Removes a member object from the extension.
Adds/removes the database object specified by the operation.
Adds/removes the name of the database object specified by the operation.
Adds/removes the name of the function specified by the operation.
Specifies the mode, name, and type of the function parameters.