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

时间：2024-04-26 16:14:01

云数据库 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-ALTER EXTENSION:注意事项

下一篇：云数据库 GAUSSDB-ALTER EXTENSION:参数说明