目录

ALTER EXTENSION

用于修改扩展的SQL命令

ALTER EXTENSION 是用于修改扩展的DDL命令，包括执行版本升级。

ALTER EXTENSION 在 PostgreSQL 9.1 中添加。

变更历史

示例

使用 ALTER EXTENSION ... UPDATE 升级扩展

repmgr=# \dx repmgr
                  List of installed extensions
  Name  | Version | Schema |            Description
--------+---------+--------+------------------------------------
 repmgr | 5.1     | repmgr | Replication manager for PostgreSQL
(1 row)

repmgr=# SELECT name, version, installed
           FROM pg_available_extension_versions
          WHERE name='repmgr'
       ORDER BY version DESC
          LIMIT 1;
  name  | version | installed
--------+---------+-----------
 repmgr | 5.2     | f
(1 row)

repmgr=# ALTER EXTENSION repmgr UPDATE;
ALTER EXTENSION

repmgr=# \dx repmgr
                  List of installed extensions
  Name  | Version | Schema |            Description
--------+---------+--------+------------------------------------
 repmgr | 5.2     | repmgr | Replication manager for PostgreSQL
(1 row)

分类

DDL, Extension, SQL command

另请参阅

CREATE EXTENSION, DROP EXTENSION, extension, pg_available_extension_versions

反馈

提交关于“ALTER EXTENSION”的任何评论、建议或更正请在此处进行。