Show installed extensions and available versions

This pages show common commands how to manage your extensions.

Listing the available extensions from the PostgreSQL

1

SELECT name, default_version, installed_version  FROM pg_available_extensions;

Install a extension

1

CREATE EXTENSION [ IF NOT EXISTS ] extension_name;

Upgrade a extension

1

ALTER EXTENSION extension_name UPDATE TO 'new_version';