# phpman > man > ALTER_EXTENSION(7) ALTER [EXTENSION(7)](https://www.chedong.com/phpMan.php/man/EXTENSION/7/markdown) PostgreSQL 14.23 Documentation ALTER [EXTENSION(7)](https://www.chedong.com/phpMan.php/man/EXTENSION/7/markdown) ## NAME ALTER_EXTENSION - change the definition of an extension ## SYNOPSIS 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_ | PROCEDURE _procedure_name_ [ ( [ [ _argmode_ ] [ _argname_ ] _argtype_ [, ...] ] ) ] | ROUTINE _routine_name_ [ ( [ [ _argmode_ ] [ _argname_ ] _argtype_ [, ...] ] ) ] | 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_ [ , ... ] ## DESCRIPTION **ALTER** **EXTENSION** changes the definition of an installed extension. There are several subforms: UPDATE This form updates the extension to a newer version. The extension must supply a suitable update script (or series of scripts) that can modify the currently-installed version into the requested version. SET SCHEMA This form moves the extension's objects into another schema. The extension has to be relocatable for this command to succeed. ADD _member_object_ This form adds an existing object to the extension. This is mainly useful in extension update scripts. The object will subsequently be treated as a member of the extension; notably, it can only be dropped by dropping the extension. DROP _member_object_ This form removes a member object from the extension. This is mainly useful in extension update scripts. The object is not dropped, only disassociated from the extension. See Section 38.17 for more information about these operations. You must own the extension to use **ALTER** **EXTENSION**. The ADD/DROP forms require ownership of the added/dropped object as well. ## PARAMETERS _name_ The name of an installed extension. _new_version_ The desired new version of the extension. This can be written as either an identifier or a string literal. If not specified, **ALTER** **EXTENSION** **UPDATE** attempts to update to whatever is shown as the default version in the extension's control file. _new_schema_ The new schema for the extension. _object_name_ _aggregate_name_ _function_name_ _operator_name_ _procedure_name_ _routine_name_ The name of an object to be added to or removed from the extension. Names of tables, aggregates, domains, foreign tables, functions, operators, operator classes, operator families, procedures, routines, sequences, text search objects, types, and views can be schema-qualified. _source_type_ The name of the source data type of the cast. _target_type_ The name of the target data type of the cast. _argmode_ The mode of a function, procedure, or aggregate argument: IN, OUT, INOUT, or VARIADIC. If omitted, the default is IN. Note that **ALTER** **EXTENSION** does not actually pay any attention to OUT arguments, since only the input arguments are needed to determine the function's identity. So it is sufficient to list the IN, INOUT, and VARIADIC arguments. _argname_ The name of a function, procedure, or aggregate argument. Note that **ALTER** **EXTENSION** does not actually pay any attention to argument names, since only the argument data types are needed to determine the function's identity. _argtype_ The data type of a function, procedure, or aggregate argument. _left_type_ _right_type_ The data type(s) of the operator's arguments (optionally schema-qualified). Write NONE for the missing argument of a prefix operator. PROCEDURAL This is a noise word. _type_name_ The name of the data type of the transform. _lang_name_ The name of the language of the transform. ## EXAMPLES 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); ## COMPATIBILITY **ALTER** **EXTENSION** is a PostgreSQL extension. ## SEE ALSO CREATE EXTENSION (**CREATE**___**[EXTENSION**(7)](https://www.chedong.com/phpMan.php/man/EXTENSION/7/markdown)), DROP EXTENSION (**DROP**___**[EXTENSION**(7)](https://www.chedong.com/phpMan.php/man/EXTENSION/7/markdown)) PostgreSQL 14.23 2026 ALTER [EXTENSION(7)](https://www.chedong.com/phpMan.php/man/EXTENSION/7/markdown)