Топ-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
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

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