select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

dbdev · In-database client for installing packages from the database.dev registry. · 0.0.5 · Administration · Apache-2.0 · SQL · Not packagedpg_permissions · view object permissions and compare them with the desired state · 1.4.1 · Administration · BSD-2-Clause · SQL · Packagedddlx · DDL eXtractor functions · 0.31 · Administration · PostgreSQL · SQL · Packagedpg_column_tetris · Enforce optimal column alignment to minimize row padding · 0.1.0 · Administration · MIT · SQL · Packagedrecursively_delete · Recursively delete rows and their foreign-key dependents · 0.1.5 · Administration · MIT · SQL · Not packagedpgbouncer_wrapper · Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw · 1.2.2 · Administration · MIT · SQL · Not packagedpggit · Git-like version control for PostgreSQL schemas · 0.1.3 · Administration · MIT · SQL · Not packagedpg_drop_events · logs transaction ids of drop table, drop column, drop materialized view statements · 0.1.0 · Administration · PostgreSQL · SQL · Packagedpg_safer_settings · Functions and mechanisms for handling PostgreSQL settings more safely. · 1.0.0 · Administration · PostgreSQL · SQL · Not packagedpg_safer_settings_table_dependent_extension · A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. · forever · Administration · Unknown · SQL · Not packagedpg_safer_settings_table_dependent_subextension · A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. · monover · Administration · Unknown · SQL · Not packagedpgfr_control · Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record. · 2.28.1 · Administration · Unknown · SQL · Not packageddbpatch · PostgreSQL database patch change management extension · 1.3.0 · Administration · BSD-3-Clause · SQL · Not packagedddl_versioning · DDL object versioning with event triggers for tables, indexes, functions, and views. · 1.0 · Administration · GPL-3.0 · SQL · Not packagedpgelog · Extended logging via pseudo-autonomous transactions · 1.0.2 · Administration · PostgreSQL · SQL · Packagedcat_tools · Tools for interfacing with the PostgreSQL catalog · 0.3.0 · Administration · MIT · SQL · Packagedtrunkfingerprint · Computes comparable fingerprints of PostgreSQL database structure and optionally data. · 1.3.0 · Administration · PostgreSQL · SQL · Not packagededb_foreignkeyconstraintmanager · Manage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server · 1.0 · Administration · Unknown · SQL · Not packagedpg_catalog_get_defs · Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. · 0.1.0 · Administration · BSD-3-Clause · SQL · Not packagedpg_lock_pool · Wait on a PostgreSQL advisory lock pool · 0.0.1 · Administration · PostgreSQL · SQL · Not packagedpg_upless · Detect Useless UPDATE · 0.0.3 · Administration · PostgreSQL · SQL · Packagedpgcozy · Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. · 1.0 · Administration · PostgreSQL · SQL · Packagedvacuum_utils · SQL functions for inspecting VACUUM and ANALYZE thresholds and activity and for invoking table maintenance. · 0.1.0 · Administration · PostgreSQL · SQL · Not packagedconstr_name_unif · Uniforms the names of constraints on base tables. · 1.0.1 · Administration · MIT · SQL · Not packagedconstraint_uniform · This is an extension for uniforming the names of base table constraints. · 1.0.0 · Administration · MIT · SQL · Not packagedextension_drop · Run custom commands when an extension is dropped. · 0.1.1 · Administration · PostgreSQL · SQL · Not packagedmvtbl · Easily move tables around tablespaces · 0.0.2 · Administration · PostgreSQL · SQL · Not packagedpg_living_assertions · Executable SQL checks with verdict dates and assertion history · 0.4.1 · Administration · PostgreSQL · SQL · Packagedpg_promise_guard · Catalog-only checks for schema guarantees that are no longer enforced · 0.2.0 · Administration · PostgreSQL · SQL · Not packagedcheck_updates · Trigger functions to allow/deny certain type of table updates · 1.0.1 · Administration · PostgreSQL · SQL · Not packagedgbdchecks · Database health-check functions and views for bloat, locks, query statistics, and privileges. · 1.1 · Administration · GPL-3.0 · SQL · Not packagedmansueli-function_vc · In database version control for postgres functions · 1.0.1 · Administration · Unknown · SQL · Not packagedpg_adm · A PostgreSQL extension providing some administrative tools. · 0.0.1 · Administration · GPL-3.0 · SQL · Not packagedpg_protect_columns · A set of postgres functions that allow you to protect columns that should not be updated. · 0.0.2 · Administration · Unknown · SQL · Not packagedpg_restore_points · Create, catalog, list, and remove named PostgreSQL restore points. · 1.0 · Administration · Unknown · SQL · Not packagedpgeyes · PL/pgSQL administrative helper extension with a pgeyes() environment check and foreign_db metadata table. · 0.0.2 · Administration · MIT · SQL · Not packagedraminder-function_vc · In database version control for postgres functions · 2.0.0 · Administration · Unknown · SQL · Not packagedskitch-extension-verify · PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. · 0.0.7 · Administration · MIT · SQL · Not packagedsoftvisio_admin · Proprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink. · 1.2.9 · Administration · Proprietary · SQL · Not packaged

39 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
dbdev 0.0.5 In-database client for installing packages from the database.dev registry. ADMIN Apache-2.0 SQL 441
pg_permissions 1.4.1 view object permissions and compare them with the desired state ADMIN BSD-2-Clause SQL 14–18 167
ddlx 0.31 DDL eXtractor functions ADMIN PostgreSQL SQL 14–18 156
pg_column_tetris 0.1.0 Enforce optimal column alignment to minimize row padding ADMIN MIT SQL 14–18 100
recursively_delete 0.1.5 Recursively delete rows and their foreign-key dependents ADMIN MIT SQL 10–13 29
pgbouncer_wrapper 1.2.2 Monitor and control the PgBouncer administration console through SQL views and functions backed by dblink_fdw ADMIN MIT SQL 20
pggit 0.1.3 Git-like version control for PostgreSQL schemas ADMIN MIT SQL 9
pg_drop_events 0.1.0 logs transaction ids of drop table, drop column, drop materialized view statements ADMIN PostgreSQL SQL 14–18 7
pg_safer_settings 1.0.0 Functions and mechanisms for handling PostgreSQL settings more safely. ADMIN PostgreSQL SQL 7
pg_safer_settings_table_dependent_extension forever A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. ADMIN SQL 7
pg_safer_settings_table_dependent_subextension monover A handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. ADMIN SQL 7
pgfr_control 2.28.1 Vacuum diagnostics, autovacuum scale-factor recommendations, and table bloat analysis for pgfr_record. ADMIN SQL 7
dbpatch 1.3.0 PostgreSQL database patch change management extension ADMIN BSD-3-Clause SQL 6
ddl_versioning 1.0 DDL object versioning with event triggers for tables, indexes, functions, and views. ADMIN GPL-3.0 SQL 13–18 5
pgelog 1.0.2 Extended logging via pseudo-autonomous transactions ADMIN PostgreSQL SQL 14–18 4
cat_tools 0.3.0 Tools for interfacing with the PostgreSQL catalog ADMIN MIT SQL 14–18 3
trunkfingerprint 1.3.0 Computes comparable fingerprints of PostgreSQL database structure and optionally data. ADMIN PostgreSQL SQL 10–15 3
edb_foreignkeyconstraintmanager 1.0 Manage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server ADMIN SQL 2
pg_catalog_get_defs 0.1.0 Adds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. ADMIN BSD-3-Clause SQL 2
pg_lock_pool 0.0.1 Wait on a PostgreSQL advisory lock pool ADMIN PostgreSQL SQL 12–17 2
pg_upless 0.0.3 Detect Useless UPDATE ADMIN PostgreSQL SQL 14–18 2
pgcozy 1.0 Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. ADMIN PostgreSQL SQL 14–18 2
vacuum_utils 0.1.0 SQL functions for inspecting VACUUM and ANALYZE thresholds and activity and for invoking table maintenance. ADMIN PostgreSQL SQL 10–18 2
constr_name_unif 1.0.1 Uniforms the names of constraints on base tables. ADMIN MIT SQL 10–18 1
constraint_uniform 1.0.0 This is an extension for uniforming the names of base table constraints. ADMIN MIT SQL 1
extension_drop 0.1.1 Run custom commands when an extension is dropped. ADMIN PostgreSQL SQL 1
mvtbl 0.0.2 Easily move tables around tablespaces ADMIN PostgreSQL SQL 1
pg_living_assertions 0.4.1 Executable SQL checks with verdict dates and assertion history ADMIN PostgreSQL SQL 14–18 1
pg_promise_guard 0.2.0 Catalog-only checks for schema guarantees that are no longer enforced ADMIN PostgreSQL SQL 13–19 1
check_updates 1.0.1 Trigger functions to allow/deny certain type of table updates ADMIN PostgreSQL SQL
gbdchecks 1.1 Database health-check functions and views for bloat, locks, query statistics, and privileges. ADMIN GPL-3.0 SQL 11
mansueli-function_vc 1.0.1 In database version control for postgres functions ADMIN SQL
pg_adm 0.0.1 A PostgreSQL extension providing some administrative tools. ADMIN GPL-3.0 SQL 10–18
pg_protect_columns 0.0.2 A set of postgres functions that allow you to protect columns that should not be updated. ADMIN SQL
pg_restore_points 1.0 Create, catalog, list, and remove named PostgreSQL restore points. ADMIN SQL
pgeyes 0.0.2 PL/pgSQL administrative helper extension with a pgeyes() environment check and foreign_db metadata table. ADMIN MIT SQL 10–18
raminder-function_vc 2.0.0 In database version control for postgres functions ADMIN SQL
skitch-extension-verify 0.0.7 PL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. ADMIN MIT SQL
softvisio_admin 1.2.9 Proprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink. ADMIN Proprietary SQL