Extensions installed by PostgreSQL database

The node displays information about installed extensions in the database PostgreSQL , as well as detailed information about them and allows you to install / remove them

Request

select ex.oid,
ex.extname,
u.usename,
ex.extnamespace,
ex.extrelocatable,
ex.extversion,
cast(ex.extconfig as text) "extconfig",
cast(ex.extcondition as text) "extcondition"
from pg_catalog.pg_extension ex,
pg_catalog.pg_user u
where ex.extowner = u.usesysid

Extension Editor

The editor allows you to install / remove the default extensions supplied with the contrib package

Query to retrieve data

select e.name,
e.default_version,
e.installed_version,
e.comment
from pg_catalog.pg_available_extensions e

Installing an extension

Select extension with status "no added"
Press the button "Install"

create extension ____;

Removing an extension

Select extension with status "added"
Press the button "Remove"

drop extension ____;