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
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
Highlight extension with status "no added"
Press the "Install" button
create extension ____;
Removing an extension
Select extension with status "added"
Press the "Remove" button
drop extension ____;