Contents
ALTER EXTENSION
A DDL 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
PROCEDUREandROUTINEmember objects added (commit e4128ee7)
- support for
- PostgreSQL 9.6
- support for
ACCESS METHODmember objects added (commit e8bdee27; note this was actually added in PostgreSQL 9.6.1)
- support for
- PostgreSQL 9.5
- support for
TRANSFORMmember 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