Repository: PGDG
121 extensions
-
pg_cron
Job scheduler for PostgreSQL
-
pg_background
Run SQL queries in the background
-
postgis
PostGIS geometry and geography spatial types and functions
-
postgis_topology
PostGIS topology spatial types and functions
-
postgis_raster
PostGIS raster types and functions
-
postgis_sfcgal
PostGIS SFCGAL functions
-
postgis_tiger_geocoder
PostGIS tiger geocoder and reverse geocoder
-
address_standardizer
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
-
address_standardizer_data_us
Address Standardizer US dataset example
-
pgrouting
pgRouting Extension
-
pointcloud
data type for lidar point clouds
-
pointcloud_postgis
integration for pointcloud LIDAR data and PostGIS geometry data
-
h3
H3 bindings for PostgreSQL
-
h3_postgis
H3 PostGIS integration
-
q3c
q3c sky indexing plugin
-
ogr_fdw
foreign-data wrapper for GIS data access
-
vector
vector data type and ivfflat and hnsw access methods
-
pg_bigm
create 2-gram (bigram) index for faster full text search.
-
pg_partman
Extension to manage partitioned tables by time or ID
-
pg_strom
PG-Strom - big-data processing acceleration using GPU and NVME
-
pgq
Generic queue for PostgreSQL
-
hll
type for storing hyperloglog data
-
jsquery
data type for jsonb inspection
-
pg_hint_plan
Give PostgreSQL ability to manually force some decisions in execution plans.
-
hypopg
Hypothetical indexes for PostgreSQL
-
pg_ivm
incremental view maintenance on PostgreSQL
-
pldbgapi
server-side support for debugging PL/pgSQL functions
-
plprofiler
server-side support for profiling PL/pgSQL functions
-
plsh
PL/sh procedural language
-
pljava
PL/Java procedural language
-
plr
load R interpreter and execute R script from within a database
-
plxslt
XSLT procedural language for PostgreSQL
-
pgtap
Unit testing for PostgreSQL
-
faker
Wrapper for the Faker Python library
-
dbt2
OSDL-DBT-2 test kit
-
prefix
Prefix Range module for PostgreSQL
-
semver
Semantic version data type
-
unit
SI units extension
-
roaringbitmap
support for Roaring Bitmaps
-
ip4r
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
-
debversion
Debian version number data type
-
timestamp9
timestamp nanosecond resolution
-
gzip
gzip and gunzip functions.
-
http
HTTP client for PostgreSQL, allows web page retrieval inside the database.
-
icu_ext
Access ICU functions
-
pg_readme
Generate a Markdown README from PostgreSQL COMMENT objects
-
pg_readme_test_extension
Fixture extension used to test pg_readme document generation
-
pg_uuidv7
Create UUIDv7 values in postgres
-
sequential_uuids
generator of sequential UUIDs
-
topn
type for top-n JSONB
-
tdigest
Provides tdigest aggregate function.
-
extra_window_functions
Extra Window Functions for PostgreSQL
-
pg_repack
Reorganize tables in PostgreSQL databases with minimal locks
-
pg_squeeze
A tool to remove unused space from a relation.
-
pgfincore
examine and manage the os buffer cache
-
prioritize
get and set the priority of PostgreSQL backends
-
pg_checksums
Activate/deactivate/verify checksums in offline Postgres clusters
-
pg_readonly
cluster database read only
-
pg_permissions
view object permissions and compare them with the desired state
-
pgautofailover
pg_auto_failover
-
pg_catcheck
Diagnosing system catalog corruption
-
pgdisablelogerror
Disable selected SQLSTATE error codes from PostgreSQL server logging.
-
safeupdate
Require criteria for UPDATE and DELETE
-
pgagent
A PostgreSQL job scheduler
-
pgpool_adm
Administrative functions for pgPool
-
pgpool_recovery
recovery functions for pgpool-II for V4.3
-
pgpool_regclass
replacement for regclass
-
pg_profile
PostgreSQL load profile repository and report builder
-
pg_stat_log
Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
-
pg_stat_plans
Track per-plan call counts, execution times, and example EXPLAIN texts.
-
pg_statviz
Capture PostgreSQL statistics snapshots for time-series analysis and visualization
-
pg_show_plans
show query plans of all currently running SQL statements
-
pg_stat_kcache
Kernel statistics gathering
-
pg_qualstats
An extension collecting statistics about quals
-
pg_track_settings
Track settings changes
-
system_stats
EnterpriseDB system statistics for PostgreSQL
-
bgw_replstatus
Small PostgreSQL background worker to report whether a node is a replication master or standby
-
powa
PostgreSQL Workload Analyser-core
-
passwordcheck_cracklib
Strengthen PostgreSQL user password checks with cracklib
-
pgsodium
Postgres extension for libsodium functions
-
passwordpolicy
Dynamically configurable PostgreSQL password complexity checks.
-
pgaudit
provides auditing functionality
-
pgauditlogtofile
pgAudit addon to redirect audit log to an independent file
-
logerrors
Function for collecting statistics about messages in logfile
-
pg_auth_mon
monitor connection attempts per user
-
pg_jobmon
Extension for logging and monitoring functions in PostgreSQL
-
credcheck
credcheck - postgresql plain text credential checker
-
pg_pwhash
Advanced password hashing methods for PostgreSQL
-
login_hook
login_hook - hook to execute login_hook.login() at login time
-
set_user
similar to SET ROLE but with added logging
-
pgextwlist
PostgreSQL Extension Whitelisting
-
multicorn
Fetch foreign data in Python in your PostgreSQL server.
-
odbc_fdw
Foreign data wrapper for accessing remote databases using ODBC
-
pgspider_ext
foreign-data wrapper for remote PGSpider servers
-
mysql_fdw
Foreign data wrapper for querying a MySQL server
-
oracle_fdw
foreign data wrapper for Oracle access
-
tds_fdw
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
-
db2_fdw
foreign data wrapper for DB2 access
-
sqlite_fdw
SQLite Foreign Data Wrapper
-
pgbouncer_fdw
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
-
informix_fdw
Foreign data wrapper for Informix access
-
mongo_fdw
foreign data wrapper for MongoDB access
-
hdfs_fdw
foreign-data wrapper for remote hdfs servers
-
orafce
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
-
pgtt
Extension to add Global Temporary Tables feature to PostgreSQL
-
pg_statement_rollback
Server side rollback at statement level for PostgreSQL like Oracle or DB2
-
plpgsql_wrap
Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
-
pg_dbms_metadata
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
-
pg_dbms_lock
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
-
pg_dbms_job
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
-
pg_dbms_errlog
Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
-
pg_utl_smtp
Oracle UTL_SMTP compatibility extension for PostgreSQL
-
pgmemcache
memcached interface
-
pglogical
PostgreSQL Logical Replication
-
pglogical_origin
Dummy extension for compatibility when upgrading from Postgres 9.4
-
pglogical_ticker
Have an accurate view on pglogical replication delay
-
pgl_ddl_deploy
automated ddl deployment using pglogical
-
wal2json
Changing data capture in JSON format
-
decoderbufs
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
-
repmgr
Replication manager for PostgreSQL
-
pg_fact_loader
build fact tables with Postgres