Contents
ALTER EXTENSION
An SQL command for modifying an extension
ALTER EXTENSION
is a DDL command for modifying an extension, including performing version upgrades.
ALTER EXTENSION
was added in PostgreSQL 9.1.
Change history
- PostgreSQL 11
- support for
PROCEDURE
andROUTINE
member objects added (commit e4128ee7)
- support for
- PostgreSQL 9.6
- support for
ACCESS METHOD
member objects added (commit e8bdee27; note this was actually added in PostgreSQL 9.6.1)
- support for
- PostgreSQL 9.5
- support for
TRANSFORM
member objects added (commit cac76582)
- support for
- PostgreSQL 9.3
- PostgreSQL 9.1
- added (commit d9572c4e)
Examples
Upgrading an extension using 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)
References
- PostgreSQL documentation: ALTER EXTENSION