Shareware software
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 ____;