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
cast(ex.extconfig as text) "extconfig",
cast(ex.extcondition as text) "extcondition"
from pg_catalog.pg_extension ex,
where ex.extowner = u.usesysid
The editor allows you to install / remove the default extensions supplied with the contrib package
Query to retrieve data
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 ____;