• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. ALTER EXTENSION

ALTER EXTENSION

Function

ALTER EXTENSION modifies the definition of an extension.

Precautions

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.

Syntax

  • Update the extension to a new version.
    ALTER EXTENSION name UPDATE [ TO new_version ];
  • Update the extension to a new schema.
    ALTER EXTENSION name SET SCHEMA new_schema;
  • Add an existing object to the extension.
    ALTER EXTENSION name ADD member_object;
  • Remove a member object from the extension.
    ALTER EXTENSION name DROP member_object;
  • The database object member_object is specified.
      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

Parameter Description

  • name

    Specifies the name of an extension.

    Value range: A string indicating an existing extension.

  • UPDATE [ TO new_version ]

    Updates the extension to a new version.

  • SET SCHEMA new_schema

    Updates the extension to a new schema.

  • ADD member_object

    Adds an existing object to the extension.

  • DROP member_object

    Removes a member object from the extension.

  • member_object

    Adds/removes the database object specified by the operation.

  • object_name

    Adds/removes the name of the database object specified by the operation.

  • function_name

    Adds/removes the name of the function specified by the operation.

  • argmode,argname,argtype

    Specifies the mode, name, and type of the function parameters.