Топ-100
 
CerebroSQL

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

PostgreSQL extension list.jpg
Request
Pane

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

Postgresql extension installer.jpg
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
  • 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 ____;