云数据库 GaussDB-ALTER EXTENSION:语法格式

时间：2025-01-26 10:48:52

云数据库 GaussDB

语法格式

修改扩展的版本

ALTER EXTENSION name UPDATE [ TO new_version ];

修改扩展的模式

ALTER EXTENSION name SET SCHEMA new_schema;

添加或删除扩展的成员对象

ALTER EXTENSION name { ADD | DROP } member_object;

其中成员对象member_object写法为：

  AGGREGATE agg_name (agg_type [, ...] ) |  CAST (source_type AS target_type) |  COLLATION object_name |  CONVERSION object_name |  DOMAIN object_name |  EVENT TRIGGER object_name |  FOREIGN DATA WRAPPER object_name |    FUNCTION function_name ( [ [ argname ] [ argmode ] 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 |  TYPE object_name |  VIEW object_name

上一篇：云数据库 GaussDB-TIMECAPSULE TABLE:注意事项

下一篇：云数据库 GaussDB-ALTER EXTENSION:示例