ALTER EXTENSION SQL Command

<refentry id="sql-alterextension"> <indexterm zone="sql-alterextension"> <primary>ALTER EXTENSION</primary> </indexterm> <refmeta> <refentrytitle>ALTER EXTENSION</refentrytitle> <manvolnum>7</manvolnum> <refmiscinfo>SQL - Language Statements</refmiscinfo> </refmeta> <refnamediv> <refname>ALTER EXTENSION</refname> <refpurpose> change the definition of an extension </refpurpose> </refnamediv> <refsynopsisdiv> <synopsis> ALTER EXTENSION <replaceable class="parameter">name</replaceable> UPDATE [ TO <replaceable class="parameter">new_version</replaceable> ] ALTER EXTENSION <replaceable class="parameter">name</replaceable> SET SCHEMA <replaceable class="parameter">new_schema</replaceable> ALTER EXTENSION <replaceable class="parameter">name</replaceable> ADD <replaceable class="parameter">member_object</replaceable> ALTER EXTENSION <replaceable class="parameter">name</replaceable> DROP <replaceable class="parameter">member_object</replaceable> <phrase>where <replaceable class="parameter">member_object</replaceable> is:</phrase> ACCESS METHOD <replaceable class="parameter">object_name</replaceable> | AGGREGATE <replaceable class="parameter">aggregate_name</replaceable> ( <replaceable>aggregate_signature</replaceable> ) | CAST (<replaceable>source_type</replaceable> AS <replaceable>target_type</replaceable>) | COLLATION <replaceable class="parameter">object_name</replaceable> | CONVERSION <replaceable class="parameter">object_name</replaceable> | DOMAIN <replaceable class="parameter">object_name</replaceable> | EVENT TRIGGER <replaceable class="parameter">object_name</replaceable> | FOREIGN DATA WRAPPER <replaceable class="parameter">object_name</replaceable> | FOREIGN TABLE <replaceable class="parameter">object_name</replaceable> | FUNCTION <replaceable class="parameter">function_name</replaceable> [ ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) ] | MATERIALIZED VIEW <replaceable class="parameter">object_name</replaceable> | OPERATOR <replaceable class="parameter">operator_name</replaceable> (<replaceable class="parameter">left_type</replaceable>, <replaceable class="parameter">right_type</replaceable>) | OPERATOR CLASS <replaceable class="parameter">object_name</replaceable> USING <replaceable class="parameter">index_method</replaceable> | OPERATOR FAMILY <replaceable class="parameter">object_name</replaceable> USING <replaceable class="parameter">index_method</replaceable> | [ PROCEDURAL ] LANGUAGE <replaceable class="parameter">object_name</replaceable> | PROCEDURE <replaceable class="parameter">procedure_name</replaceable> [ ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) ] | ROUTINE <replaceable class="parameter">routine_name</replaceable> [ ( [ [ <replaceable class="parameter">argmode</replaceable> ] [ <replaceable class="parameter">argname</replaceable> ] <replaceable class="parameter">argtype</replaceable> [, ...] ] ) ] | SCHEMA <replaceable class="parameter">object_name</replaceable> | SEQUENCE <replaceable class="parameter">object_name</replaceable> | SERVER <replaceable class="parameter">object_name</replaceable> | TABLE <replaceable class="parameter">object_name</replaceable> | TEXT SEARCH CONFIGURATION <replaceable class="parameter">object_name</replaceable> | TEXT SEARCH DICTIONARY <replaceable class="parameter">object_name</replaceable> | TEXT SEARCH PARSER <replaceable class="parameter">object_name</replaceable> | TEXT SEARCH TEMPLATE <replaceable class="parameter">object_name</replaceable> | TRANSFORM FOR <replaceable>type_name</replaceable> LANGUAGE <replaceable>lang_name</replaceable> | TYPE <replaceable

The SQL command `ALTER EXTENSION` modifies the definition of an extension. It allows updating to a new version, setting a new schema, adding or dropping member objects such as access methods, aggregates, casts, collations, conversions, domains, event triggers, foreign data wrappers, foreign tables, functions, materialized views, operators, operator classes, operator families, languages, procedures, routines, schemas, sequences, servers, tables, text search configurations/dictionaries/parsers/templates, transforms, and types.