This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Extension List

The complete 400 PostgreSQL Extension List available in Pigsty

There are 400 available extensions in Pigsty, including 393 RPM extensions available in EL and 387 DEB extensions available in Debian/Ubuntu. There are 69 Contrib extensions provided by PostgreSQL and 331 additional third-party extensions provide by PGDG & Pigsty.

Name (Detail) Package (Repo) Repo Version Category License LOAD DDL TRUST RELOC Description
timescaledb timescaledb PIGSTY 2.18.1 TIME Timescale Enables scalable inserts and complex queries for time-series data
timescaledb_toolkit timescaledb_toolkit PIGSTY 1.19.0 TIME Timescale Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
timeseries pg_timeseries PIGSTY 0.1.6 TIME PostgreSQL Convenience API for Tembo time series stack
periods periods PGDG 1.2 TIME PostgreSQL Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tables temporal_tables PIGSTY 1.2.2 TIME BSD 2 temporal tables
emaj emaj PIGSTY 4.5.0 TIME GPLv3 Enables fine-grained write logging and time travel on subsets of the database.
table_version table_version PIGSTY 1.11.1 TIME BSD 3 PostgreSQL table versioning extension
pg_cron pg_cron PGDG 1.6 TIME PostgreSQL Job scheduler for PostgreSQL
pg_task pg_task PGDG 1.0.0 TIME MIT execute any sql command at any specific time at background
pg_later pg_later PIGSTY 0.3.0 TIME PostgreSQL pg_later: Run queries now and get results later
pg_background pg_background PIGSTY 1.3 TIME GPLv3 Run SQL queries in the background
postgis postgis PGDG 3.5.2 GIS GPLv2 PostGIS geometry and geography spatial types and functions
postgis_topology postgis PGDG 3.5.2 GIS GPLv2 PostGIS topology spatial types and functions
postgis_raster postgis PGDG 3.5.2 GIS GPLv2 PostGIS raster types and functions
postgis_sfcgal postgis PGDG 3.5.2 GIS GPLv2 PostGIS SFCGAL functions
postgis_tiger_geocoder postgis PGDG 3.5.2 GIS GPLv2 PostGIS tiger geocoder and reverse geocoder
address_standardizer postgis PGDG 3.5.2 GIS GPLv2 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us postgis PGDG 3.5.2 GIS GPLv2 Address Standardizer US dataset example
pgrouting pgrouting PGDG 3.7.3 GIS GPLv2 pgRouting Extension
pointcloud pointcloud PIGSTY 1.2.5 GIS BSD 3 data type for lidar point clouds
pointcloud_postgis pointcloud PGDG 1.2.5 GIS BSD 3 integration for pointcloud LIDAR data and PostGIS geometry data
h3 pg_h3 PGDG 4.2.2 GIS Apache-2.0 H3 bindings for PostgreSQL
h3_postgis pg_h3 PGDG 4.2.2 GIS Apache-2.0 H3 PostGIS integration
q3c q3c PIGSTY 2.0.1 GIS GPLv2 q3c sky indexing plugin
ogr_fdw ogr_fdw PGDG 1.1 GIS MIT foreign-data wrapper for GIS data access
geoip geoip PIGSTY 0.3.0 GIS BSD 2 IP-based geolocation query
pg_polyline pg_polyline PIGSTY 0.0.1 GIS MIT Fast Google Encoded Polyline encoding & decoding for postgres
pg_geohash pg_geohash PIGSTY 1.0 GIS MIT Handle geohash based functionality for spatial coordinates
mobilitydb mobilitydb PGDG 1.1.1 GIS GPLv3 MobilityDB geospatial trajectory data management & analysis platform
earthdistance earthdistance CONTRIB 1.1 GIS PostgreSQL calculate great-circle distances on the surface of the Earth
vector pgvector PGDG 0.8.0 RAG PostgreSQL vector data type and ivfflat and hnsw access methods
vchord vchord PIGSTY 0.2.0 RAG AGPLv3 Vector database plugin for Postgres, written in Rust
vectorscale pgvectorscale PIGSTY 0.5.1 RAG PostgreSQL pgvectorscale: Advanced indexing for vector data
vectorize pg_vectorize PIGSTY 0.21.1 RAG PostgreSQL The simplest way to do vector search on Postgres
pg_similarity pg_similarity PIGSTY 1.0 RAG BSD 3 support similarity queries
smlar smlar PIGSTY 1.0 RAG PostgreSQL Effective similarity search
pg_summarize pg_summarize PIGSTY 0.0.1 RAG PostgreSQL Text Summarization using LLMs. Built using pgrx
pg_tiktoken pg_tiktoken PIGSTY 0.0.1 RAG Apache-2.0 pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres
pg4ml pg4ml PIGSTY 2.0 RAG AGPLv3 Machine learning framework for PostgreSQL
pgml pgml PIGSTY 2.10.0 RAG MIT PostgresML: Run AL/ML workloads with SQL interface
pg_search pg_search PIGSTY 0.15.1 FTS AGPLv3 pg_search: Full text search for PostgreSQL using BM25
pgroonga pgroonga PIGSTY 4.0.0 FTS PostgreSQL Use Groonga as index, fast full text search platform for all languages!
pgroonga_database pgroonga PIGSTY 4.0.0 FTS PostgreSQL PGroonga database management module
pg_bigm pg_bigm PIGSTY 1.2 FTS PostgreSQL create 2-gram (bigram) index for faster full text search.
zhparser zhparser PIGSTY 2.3 FTS PostgreSQL a parser for full-text search of Chinese
pg_bestmatch pg_bestmatch PIGSTY 0.0.1 FTS Apache-2.0 Generate BM25 sparse vector inside PostgreSQL
vchord_bm25 vchord_bm25 PIGSTY 0.1.0 FTS AGPLv3 A postgresql extension for bm25 ranking algorithm
hunspell_cs_cz hunspell_cs_cz PIGSTY 1.0 FTS PostgreSQL Czech Hunspell Dictionary
hunspell_de_de hunspell_de_de PIGSTY 1.0 FTS PostgreSQL German Hunspell Dictionary
hunspell_en_us hunspell_en_us PIGSTY 1.0 FTS PostgreSQL en_US Hunspell Dictionary
hunspell_fr hunspell_fr PIGSTY 1.0 FTS PostgreSQL French Hunspell Dictionary
hunspell_ne_np hunspell_ne_np PIGSTY 1.0 FTS PostgreSQL Nepali Hunspell Dictionary
hunspell_nl_nl hunspell_nl_nl PIGSTY 1.0 FTS PostgreSQL Dutch Hunspell Dictionary
hunspell_nn_no hunspell_nn_no PIGSTY 1.0 FTS PostgreSQL Norwegian (norsk) Hunspell Dictionary
hunspell_pt_pt hunspell_pt_pt PIGSTY 1.0 FTS PostgreSQL Portuguese Hunspell Dictionary
hunspell_ru_ru hunspell_ru_ru PIGSTY 1.0 FTS PostgreSQL Russian Hunspell Dictionary
hunspell_ru_ru_aot hunspell_ru_ru_aot PIGSTY 1.0 FTS PostgreSQL Russian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatch fuzzystrmatch CONTRIB 1.2 FTS PostgreSQL determine similarities and distance between strings
pg_trgm pg_trgm CONTRIB 1.6 FTS PostgreSQL text similarity measurement and index searching based on trigrams
citus citus PIGSTY 13.0.1 OLAP AGPLv3 Distributed PostgreSQL as an extension
citus_columnar citus PIGSTY 11.3-1 OLAP AGPLv3 Citus columnar storage engine
columnar hydra PIGSTY 11.1-11 OLAP AGPLv3 Hydra Columnar extension
pg_analytics pg_analytics PIGSTY 0.3.3 OLAP PostgreSQL Postgres for analytics, powered by DuckDB
pg_duckdb pg_duckdb PIGSTY 0.2.0 OLAP MIT DuckDB Embedded in Postgres
pg_mooncake pg_mooncake PIGSTY 0.1.0 OLAP MIT Columnstore Table in Postgres
duckdb_fdw duckdb_fdw PIGSTY 1.1.2 OLAP MIT DuckDB Foreign Data Wrapper
pg_parquet pg_parquet PIGSTY 0.2.0 OLAP PostgreSQL copy data between Postgres and Parquet
pg_fkpart pg_fkpart PIGSTY 1.7 OLAP GPLv2 Table partitioning by foreign key utility
pg_partman pg_partman PGDG 5.2.4 OLAP PostgreSQL Extension to manage partitioned tables by time or ID
plproxy plproxy PGDG 2.11.0 OLAP BSD 0 Database partitioning implemented as procedural language
pg_strom pg_strom PGDG 5.1 OLAP PostgreSQL PG-Strom - big-data processing acceleration using GPU and NVME
tablefunc tablefunc CONTRIB 1.0 OLAP PostgreSQL functions that manipulate whole tables, including crosstab
omni omnigres PIGSTY 0.2.4 FEAT Apache-2.0 Advanced adapter for Postgres extensions
omni_auth omnigres PIGSTY 0.1.2 FEAT Apache-2.0 Basic session management
omni_aws omnigres PIGSTY 0.1.2 FEAT Apache-2.0 Amazon Web Services APIs (S3)
omni_containers omnigres PIGSTY 0.2.0 FEAT Apache-2.0 Docker container management
omni_credentials omnigres PIGSTY 0.1.0 FEAT Apache-2.0 Application credential management
omni_http omnigres PIGSTY 0.1.0 FEAT Apache-2.0 Basic HTTP types
omni_httpc omnigres PIGSTY 0.1.4 FEAT Apache-2.0 HTTP client
omni_httpd omnigres PIGSTY 0.2.9 FEAT Apache-2.0 HTTP server
omni_id omnigres PIGSTY 0.4.0 FEAT Apache-2.0 Identity types
omni_json omnigres PIGSTY 0.1.1 FEAT Apache-2.0 JSON toolkit
omni_kube omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Kubernetes (k8s) integration
omni_ledger omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Financial ledger
omni_manifest omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Package installation manifests
omni_mimetypes omnigres PIGSTY 0.1.0 FEAT Apache-2.0 MIME types
omni_os omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Operating system integration
omni_polyfill omnigres PIGSTY 0.2.0 FEAT Apache-2.0 Postgres API polyfills
omni_python omnigres PIGSTY 0.1.1 FEAT Apache-2.0 First-class Python support
omni_regex omnigres PIGSTY 0.1.0 FEAT Apache-2.0 PCRE-compatible regular expressions
omni_rest omnigres PIGSTY 0.1.0 FEAT Apache-2.0 REST API toolkit (with PostgREST support)
omni_schema omnigres PIGSTY 0.2.3 FEAT Apache-2.0 Advanced schema management tooling
omni_seq omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Distributed integer sequences
omni_service omnigres PIGSTY 0.1.0 FEAT Apache-2.0 Service management
omni_session omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Session management
omni_sql omnigres PIGSTY 0.5.0 FEAT Apache-2.0 Programmatic SQL manipulation
omni_test omnigres PIGSTY 0.1.0 FEAT Apache-2.0 Testing framework
omni_txn omnigres PIGSTY 0.5.0 FEAT Apache-2.0 Transaction management
omni_types omnigres PIGSTY 0.2.1 FEAT Apache-2.0 Advanced types
omni_var omnigres PIGSTY 0.3.0 FEAT Apache-2.0 Scoped variables
omni_vfs omnigres PIGSTY 0.2.0 FEAT Apache-2.0 Virtual File System
omni_vfs_types_v1 omnigres PIGSTY 0.1.0 FEAT Apache-2.0 Virtual File System types (v1)
omni_web omnigres PIGSTY 0.1.1 FEAT Apache-2.0 Common web stack primitives
omni_xml omnigres PIGSTY 0.1.2 FEAT Apache-2.0 XML toolkit
omni_yaml omnigres PIGSTY 0.1.0 FEAT Apache-2.0 YAML toolkit
documentdb_core pg_documentdb_core PIGSTY 0.100-0 FEAT MIT Core API surface for DocumentDB on PostgreSQL
age age PIGSTY 1.5.0 FEAT Apache-2.0 AGE graph database extension
hll hll PGDG 2.18 FEAT Apache-2.0 type for storing hyperloglog data
rum rum PGDG 1.3 FEAT PostgreSQL RUM index access method
pg_graphql pg_graphql PIGSTY 1.5.9 FEAT Apache-2.0 pg_graphql: GraphQL support
pg_jsonschema pg_jsonschema PIGSTY 0.3.3 FEAT Apache-2.0 PostgreSQL extension providing JSON Schema validation
jsquery jsquery PGDG 1.1 FEAT PostgreSQL data type for jsonb inspection
pg_hint_plan pg_hint_plan PGDG 1.7.0 FEAT BSD 3 Give PostgreSQL ability to manually force some decisions in execution plans.
hypopg hypopg PGDG 1.4.1 FEAT PostgreSQL Hypothetical indexes for PostgreSQL
index_advisor index_advisor PIGSTY 0.2.0 FEAT PostgreSQL Query index advisor
plan_filter pg_plan_filter PIGSTY 0.0.1 FEAT PostgreSQL filter statements by their execution plans.
imgsmlr imgsmlr PIGSTY 1.0 FEAT PostgreSQL Image similarity with haar
pg_ivm pg_ivm PIGSTY 1.9 FEAT PostgreSQL incremental view maintenance on PostgreSQL
pg_incremental pg_incremental PIGSTY 1.1 FEAT PostgreSQL Incremental Processing by Crunchy Data
pgmq pgmq PIGSTY 1.5.0 FEAT PostgreSQL A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgq pgq PGDG 3.5.1 FEAT ISC Generic queue for PostgreSQL
pg_cardano pg_cardano PIGSTY 1.0.3 FEAT MIT A suite of Cardano-related tools
rdkit rdkit PGDG 4.3.0 FEAT BSD 3 Cheminformatics functionality for PostgreSQL.
bloom bloom CONTRIB 1.0 FEAT PostgreSQL bloom access method - signature file based index
pg_tle pg_tle PIGSTY 1.2.0 LANG Apache-2.0 Trusted Language Extensions for PostgreSQL
plv8 plv8 PIGSTY 3.2.3 LANG PostgreSQL PL/JavaScript (v8) trusted procedural language
pllua pllua PGDG 2.0 LANG MIT Lua as a procedural language
hstore_pllua pllua PGDG 1.0 LANG MIT Hstore transform for Lua
plluau pllua PGDG 2.0 LANG MIT Lua as an untrusted procedural language
hstore_plluau pllua PGDG 1.0 LANG MIT Hstore transform for untrusted Lua
plprql plprql PIGSTY 1.0.0 LANG Apache-2.0 Use PRQL in PostgreSQL - Pipelined Relational Query Language
pldbgapi pldebugger PGDG 1.1 LANG Artistic server-side support for debugging PL/pgSQL functions
plpgsql_check plpgsql_check PGDG 2.7 LANG MIT extended check for plpgsql functions
plprofiler plprofiler PGDG 4.2 LANG Artistic server-side support for profiling PL/pgSQL functions
plsh plsh PGDG 2 LANG MIT PL/sh procedural language
pljava pljava PGDG 1.6.8 LANG BSD 3 PL/Java procedural language (https://tada.github.io/pljava/)
plr plr PGDG 8.4.6 LANG GPLv2 load R interpreter and execute R script from within a database
pgtap pgtap PGDG 1.3.3 LANG PostgreSQL Unit testing for PostgreSQL
faker faker PGDG 0.5.3 LANG PostgreSQL Wrapper for the Faker Python library
dbt2 dbt2 PGDG 0.45.0 LANG Artistic OSDL-DBT-2 test kit
pltcl pltcl CONTRIB 1.0 LANG PostgreSQL PL/Tcl procedural language
pltclu pltcl CONTRIB 1.0 LANG PostgreSQL PL/TclU untrusted procedural language
plperl plperl CONTRIB 1.0 LANG PostgreSQL PL/Perl procedural language
bool_plperl plperl CONTRIB 1.0 LANG PostgreSQL transform between bool and plperl
hstore_plperl plperl CONTRIB 1.0 LANG PostgreSQL transform between hstore and plperl
jsonb_plperl plperl CONTRIB 1.0 LANG PostgreSQL transform between jsonb and plperl
plperlu plperlu CONTRIB 1.0 LANG PostgreSQL PL/PerlU untrusted procedural language
bool_plperlu plperlu CONTRIB 1.0 LANG PostgreSQL transform between bool and plperlu
jsonb_plperlu plperlu CONTRIB 1.0 LANG PostgreSQL transform between jsonb and plperlu
hstore_plperlu plperlu CONTRIB 1.0 LANG PostgreSQL transform between hstore and plperlu
plpgsql plpgsql CONTRIB 1.0 LANG PostgreSQL PL/pgSQL procedural language
plpython3u plpython3u CONTRIB 1.0 LANG PostgreSQL PL/Python3U untrusted procedural language
jsonb_plpython3u plpython3u CONTRIB 1.0 LANG PostgreSQL transform between jsonb and plpython3u
ltree_plpython3u plpython3u CONTRIB 1.0 LANG PostgreSQL transform between ltree and plpython3u
hstore_plpython3u plpython3u CONTRIB 1.0 LANG PostgreSQL transform between hstore and plpython3u
prefix pg_prefix PGDG 1.2.0 TYPE PostgreSQL Prefix Range module for PostgreSQL
semver pg_semver PGDG 0.32.1 TYPE PostgreSQL Semantic version data type
unit pgunit PGDG 7 TYPE GPLv2 SI units extension
pgpdf pgpdf PIGSTY 0.1.0 TYPE GPLv3 PDF type with meta admin & Full-Text Search
pglite_fusion pglite_fusion PIGSTY 0.0.3 TYPE MIT Embed an SQLite database in your PostgreSQL table
md5hash md5hash PIGSTY 1.0.1 TYPE BSD 2 type for storing 128-bit binary data inline
asn1oid asn1oid PIGSTY 1 TYPE GPLv3 asn1oid extension
roaringbitmap roaringbitmap PIGSTY 0.5 TYPE Apache-2.0 support for Roaring Bitmaps
pgfaceting pgfaceting PIGSTY 0.2.0 TYPE BSD 3 fast faceting queries using an inverted index
pg_sphere pgsphere PIGSTY 1.5.1 TYPE BSD 3 spherical objects with useful functions, operators and index support
country pg_country PIGSTY 0.0.3 TYPE PostgreSQL Country data type, ISO 3166-1
pg_xenophile pg_xenophile PIGSTY 0.8.3 TYPE PostgreSQL More than the bare necessities for PostgreSQL i18n and l10n.
currency pg_currency PIGSTY 0.0.3 TYPE MIT Custom PostgreSQL currency type in 1Byte
pgmp pgmp PGDG 1.1 TYPE LGPLv3 Multiple Precision Arithmetic extension
numeral numeral PIGSTY 1 TYPE GPLv2 numeral datatypes extension
pg_rational pg_rational PIGSTY 0.0.2 TYPE MIT bigint fractions
uint pguint PIGSTY 0 TYPE PostgreSQL unsigned integer types
uint128 pg_uint128 PIGSTY 1.0.0 TYPE PostgreSQL Native uint128 type
hashtypes hashtypes PIGSTY 0.1.5 TYPE PostgreSQL sha1, md5 and other data types for PostgreSQL
ip4r ip4r PGDG 2.4 TYPE PostgreSQL IPv4/v6 and IPv4/v6 range index type for PostgreSQL
pg_duration pg_duration PIGSTY 1.0.1 TYPE MIT data type for representing durations
uri pg_uri PIGSTY 1 TYPE PostgreSQL URI Data type for PostgreSQL
emailaddr pgemailaddr PIGSTY 0 TYPE PostgreSQL Email address type for PostgreSQL
acl pg_acl PIGSTY 1.0.4 TYPE BSD 2 ACL Data type
debversion debversion PGDG 1.2 TYPE PostgreSQL Debian version number data type
pg_rrule pg_rrule PGDG 0.2.0 TYPE MIT RRULE field type for PostgreSQL
timestamp9 timestamp9 PIGSTY 1.4.0 TYPE MIT timestamp nanosecond resolution
chkpass chkpass PIGSTY 1.0 TYPE PostgreSQL data type for auto-encrypted passwords
isn isn CONTRIB 1.2 TYPE PostgreSQL data types for international product numbering standards
seg seg CONTRIB 1.4 TYPE PostgreSQL data type for representing line segments or floating-point intervals
cube cube CONTRIB 1.5 TYPE PostgreSQL data type for multidimensional cubes
ltree ltree CONTRIB 1.3 TYPE PostgreSQL data type for hierarchical tree-like structures
hstore hstore CONTRIB 1.8 TYPE PostgreSQL data type for storing sets of (key, value) pairs
citext citext CONTRIB 1.6 TYPE PostgreSQL data type for case-insensitive character strings
xml2 xml2 CONTRIB 1.1 TYPE PostgreSQL XPath querying and XSLT
zstd pg_zstd PIGSTY 1.1.0 UTIL ISC Zstandard compression algorithm implementation in PostgreSQL
gzip pg_gzip PIGSTY 1.0 UTIL MIT gzip and gunzip functions.
http pg_http PGDG 1.6 UTIL MIT HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net pg_net PIGSTY 0.8.0 UTIL Apache-2.0 Async HTTP Requests
pg_curl pg_curl PIGSTY 2.4 UTIL MIT Run curl actions for data transfer in URL syntax
pgjq pgjq PIGSTY 0.1.0 UTIL MIT Use jq in Postgres
pgjwt pgjwt PIGSTY 0.2.0 UTIL MIT JSON Web Token API for Postgresql
pg_smtp_client pg_smtp_client PIGSTY 0.2.0 UTIL MIT PostgreSQL extension to send email using SMTP
pg_html5_email_address pg_html5_email_address PIGSTY 1.2.3 UTIL PostgreSQL PostgreSQL email validation that is consistent with the HTML5 spec
url_encode url_encode PIGSTY 1.2 UTIL PostgreSQL url_encode, url_decode functions
pgsql_tweaks pgsql_tweaks PIGSTY 0.10.7 UTIL PostgreSQL Some functions and views for daily usage
pg_extra_time pg_extra_time PIGSTY 2.0.0 UTIL PostgreSQL Some date time functions and operators that,
pgpcre pgpcre PIGSTY 1 UTIL PostgreSQL Perl Compatible Regular Expression functions
icu_ext icu_ext PIGSTY 1.9 UTIL PostgreSQL Access ICU functions
pgqr pgqr PIGSTY 1.0 UTIL BSD 3 QR Code generator from PostgreSQL
pg_protobuf pg_protobuf PIGSTY 1.0 UTIL MIT Protobuf support for PostgreSQL
envvar envvar PIGSTY 1.0.0 UTIL PostgreSQL Fetch the value of an environment variable
floatfile floatfile PIGSTY 1.3.1 UTIL MIT Simple file storage for arrays of floats
pg_readme pg_readme PIGSTY 0.7.0 UTIL PostgreSQL Generate a README.md document for a database extension or schema
ddl_historization ddl_historization PIGSTY 0.0.7 UTIL GPLv2 Historize the ddl changes inside PostgreSQL database
data_historization data_historization PIGSTY 1.1.0 UTIL PostgreSQL PLPGSQL Script to historize data in partitionned table
schedoc pg_schedoc PIGSTY 0.0.2 UTIL GPLv3 Cross documentation between Django and DBT projects
hashlib pg_hashlib PIGSTY 1.1 UTIL PostgreSQL Stable hash functions for Postgres
xxhash pg_xxhash PIGSTY 0.0.1 UTIL BSD 2 xxhash functions for PostgreSQL
shacrypt shacrypt PIGSTY 1.1 UTIL PostgreSQL Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint cryptint PIGSTY 1.0.0 UTIL PostgreSQL Encryption functions for int and bigint values
pguecc pg_ecdsa PIGSTY 1.0 UTIL BSD 2 uECC bindings for Postgres
pg_idkit pg_idkit PIGSTY 0.2.4 FUNC Apache-2.0 multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7 pg_uuidv7 PIGSTY 1.6 FUNC MPLv2 pg_uuidv7: create UUIDv7 values in postgres
permuteseq permuteseq PIGSTY 1.2 FUNC PostgreSQL Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids pg_hashids PIGSTY 1.3 FUNC MIT Short unique id generator for PostgreSQL, using hashids
sequential_uuids sequential_uuids PIGSTY 1.0.3 FUNC MIT generator of sequential UUIDs
topn topn PGDG 2.7.0 FUNC AGPLv3 type for top-n JSONB
quantile quantile PIGSTY 1.1.8 FUNC BSD 2 Quantile aggregation function
lower_quantile lower_quantile PIGSTY 1.0.3 FUNC BSD 2 Lower quantile aggregate function
count_distinct count_distinct PIGSTY 3.0.2 FUNC BSD 2 An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
omnisketch omnisketch PIGSTY 1.0.1 FUNC PostgreSQL data structure for on-line agg of data into approximate sketch
ddsketch ddsketch PIGSTY 1.0.1 FUNC PostgreSQL Provides ddsketch aggregate function
vasco vasco PIGSTY 0.1.0 FUNC GPLv3 discover hidden correlations in your data with MIC
xicor pgxicor PIGSTY 0.1.0 FUNC GPLv3 XI Correlation Coefficient in Postgres
tdigest tdigest PGDG 1.4.3 FUNC Apache-2.0 Provides tdigest aggregate function.
first_last_agg first_last_agg PIGSTY 0.1.4 FUNC PostgreSQL first() and last() aggregate functions
extra_window_functions extra_window_functions PGDG 1.0 FUNC PostgreSQL Extra Window Functions for PostgreSQL
floatvec floatvec PIGSTY 1.1.1 FUNC MIT Math for vectors (arrays) of numbers
aggs_for_vecs aggs_for_vecs PIGSTY 1.3.2 FUNC MIT Aggregate functions for array inputs
aggs_for_arrays aggs_for_arrays PIGSTY 1.3.3 FUNC MIT Various functions for computing statistics on arrays of numbers
arraymath pg_arraymath PIGSTY 1.1 FUNC MIT Array math and operators that work element by element on the contents of arrays
pg_math pg_math PIGSTY 1.0 FUNC GPLv3 GSL statistical functions for postgresql
random pg_random PIGSTY 2.0.0-dev FUNC PostgreSQL random data generator
base36 pg_base36 PIGSTY 1.0.0 FUNC MIT Integer Base36 types
base62 pg_base62 PIGSTY 0.0.1 FUNC MIT Base62 extension for PostgreSQL
pg_base58 pg_base58 PIGSTY 0.0.1 FUNC MIT Base58 Encoder/Decoder Extension for PostgreSQL
financial pg_financial PIGSTY 1.0.1 FUNC PostgreSQL Financial aggregate functions
refint refint CONTRIB 1.0 FUNC PostgreSQL functions for implementing referential integrity (obsolete)
autoinc autoinc CONTRIB 1.0 FUNC PostgreSQL functions for autoincrementing fields
insert_username insert_username CONTRIB 1.0 FUNC PostgreSQL functions for tracking who changed a table
moddatetime moddatetime CONTRIB 1.0 FUNC PostgreSQL functions for tracking last modification time
tsm_system_time tsm_system_time CONTRIB 1.0 FUNC PostgreSQL TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn dict_xsyn CONTRIB 1.0 FUNC PostgreSQL text search dictionary template for extended synonym processing
tsm_system_rows tsm_system_rows CONTRIB 1.0 FUNC PostgreSQL TABLESAMPLE method which accepts number of rows as a limit
tcn tcn CONTRIB 1.0 FUNC PostgreSQL Triggered change notifications
uuid-ossp uuid-ossp CONTRIB 1.1 FUNC PostgreSQL generate universally unique identifiers (UUIDs)
btree_gist btree_gist CONTRIB 1.7 FUNC PostgreSQL support for indexing common datatypes in GiST
btree_gin btree_gin CONTRIB 1.3 FUNC PostgreSQL support for indexing common datatypes in GIN
intarray intarray CONTRIB 1.5 FUNC PostgreSQL functions, operators, and index support for 1-D arrays of integers
intagg intagg CONTRIB 1.1 FUNC PostgreSQL integer aggregator and enumerator (obsolete)
dict_int dict_int CONTRIB 1.0 FUNC PostgreSQL text search dictionary template for integers
unaccent unaccent CONTRIB 1.1 FUNC PostgreSQL text search dictionary that removes accents
pg_repack pg_repack PGDG 1.5.2 ADMIN BSD 3 Reorganize tables in PostgreSQL databases with minimal locks
pg_squeeze pg_squeeze PGDG 1.8 ADMIN BSD 2 A tool to remove unused space from a relation.
pg_dirtyread pg_dirtyread PIGSTY 2 ADMIN BSD 3 Read dead but unvacuumed rows from table
pgfincore pgfincore PGDG 1.3.1 ADMIN BSD 3 examine and manage the os buffer cache
pg_cooldown pg_cooldown PIGSTY 0.1 ADMIN Apache-2.0 remove buffered pages for specific relations
ddlx pg_ddlx PIGSTY 0.29 ADMIN PostgreSQL DDL eXtractor functions
prioritize pg_prioritize PGDG 1.0 ADMIN PostgreSQL get and set the priority of PostgreSQL backends
pg_checksums pg_checksums PGDG 1.1 ADMIN BSD 2 Activate/deactivate/verify checksums in offline Postgres clusters
pg_readonly pg_readonly PGDG 1.0.0 ADMIN PostgreSQL cluster database read only
pg_upless pg_upless PIGSTY 0.0.3 ADMIN PostgreSQL Detect Useless UPDATE
pg_permissions pg_permissions PIGSTY 1.3 ADMIN BSD 2 view object permissions and compare them with the desired state
pgautofailover pgautofailover PGDG 2.1 ADMIN PostgreSQL pg_auto_failover
pg_catcheck pg_catcheck PGDG 1.6.0 ADMIN BSD 3 Diagnosing system catalog corruption
pre_prepare preprepare PIGSTY 0.4 ADMIN PostgreSQL Pre Prepare your Statement server side
pgcozy pgcozy PIGSTY 1.0 ADMIN PostgreSQL Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphaned pg_orphaned PIGSTY 1.0 ADMIN PostgreSQL Deal with orphaned files
pg_crash pg_crash PIGSTY 1.0 ADMIN BSD 3 Send random signals to random processes
pg_cheat_funcs pg_cheat_funcs PIGSTY 1.0 ADMIN PostgreSQL Provides cheat (but useful) functions
fio pg_fio PIGSTY 1.0 ADMIN BSD 3 PostgreSQL File I/O Functions
pg_savior pg_savior PIGSTY 0.0.1 ADMIN Apache-2.0 Postgres extension to save OOPS mistakes
safeupdate safeupdate PGDG 1.4 ADMIN ISC Require criteria for UPDATE and DELETE
pg_drop_events pg_drop_events PGDG 0.1 ADMIN PostgreSQL logs transaction ids of drop table, drop column, drop materialized view statements
table_log table_log PIGSTY 0.6.1 ADMIN PostgreSQL record table modification logs and PITR for table/row
pgagent pgagent PGDG 4.2 ADMIN PostgreSQL A PostgreSQL job scheduler
pg_prewarm pg_prewarm CONTRIB 1.2 ADMIN PostgreSQL prewarm relation data
pgpool_adm pgpool PGDG 1.5 ADMIN PostgreSQL Administrative functions for pgPool
pgpool_recovery pgpool PGDG 1.4 ADMIN PostgreSQL recovery functions for pgpool-II for V4.3
lo lo CONTRIB 1.1 ADMIN PostgreSQL Large Object maintenance
pgpool_regclass pgpool PGDG 1.0 ADMIN PostgreSQL replacement for regclass
basic_archive basic_archive CONTRIB - ADMIN PostgreSQL an example of an archive module
basebackup_to_shell basebackup_to_shell CONTRIB - ADMIN PostgreSQL adds a custom basebackup target called shell
old_snapshot old_snapshot CONTRIB 1.0 ADMIN PostgreSQL utilities in support of old_snapshot_threshold
adminpack adminpack CONTRIB 2.1 ADMIN PostgreSQL administrative functions for PostgreSQL
amcheck amcheck CONTRIB 1.4 ADMIN PostgreSQL functions for verifying relation integrity
pg_surgery pg_surgery CONTRIB 1.0 ADMIN PostgreSQL extension to perform surgery on a damaged relation
pg_profile pg_profile PIGSTY 4.8 STAT BSD 2 PostgreSQL load profile repository and report builder
pg_tracing pg_tracing PIGSTY 0.1.0 STAT MIT Distributed Tracing for PostgreSQL
pg_show_plans pg_show_plans PGDG 2.1 STAT PostgreSQL show query plans of all currently running SQL statements
pg_stat_kcache pg_stat_kcache PGDG 2.3.0 STAT BSD 3 Kernel statistics gathering
pg_stat_monitor pg_stat_monitor PIGSTY 2.1 STAT BSD 3 The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
pg_qualstats pg_qualstats PGDG 2.1.1 STAT BSD 3 An extension collecting statistics about quals
pg_store_plans pg_store_plans PIGSTY 1.8 STAT BSD 3 track plan statistics of all SQL statements executed
pg_track_settings pg_track_settings PGDG 2.1.2 STAT PostgreSQL Track settings changes
pg_wait_sampling pg_wait_sampling PGDG 1.1 STAT PostgreSQL sampling based statistics of wait events
system_stats system_stats PIGSTY 3.0 STAT PostgreSQL EnterpriseDB system statistics for PostgreSQL
meta pg_meta PIGSTY 0.4.0 STAT BSD 2 Normalized, friendlier system catalog for PostgreSQL
pgnodemx pgnodemx PIGSTY 1.7 STAT Apache-2.0 Capture node OS metrics via SQL queries
pg_proctab pgnodemx PIGSTY 0.0.10-compat STAT BSD 3 PostgreSQL extension to access the OS process table
pg_sqlog pg_sqlog PIGSTY 1.6 STAT BSD 3 Provide SQL interface to logs
bgw_replstatus bgw_replstatus PGDG 1.0.6 STAT PostgreSQL Small PostgreSQL background worker to report whether a node is a replication master or standby
pgmeminfo pgmeminfo PIGSTY 1.0 STAT MIT show memory usage
toastinfo toastinfo PIGSTY 1 STAT PostgreSQL show details on toasted datums
explain_ui pg_explain_ui PIGSTY 0.0.1 STAT PostgreSQL easily jump into a visual plan UI for any SQL query
pg_relusage pg_relusage PIGSTY 0.0.1 STAT PostgreSQL Log all the queries that reference a particular column
pagevis pagevis PIGSTY 0.1 STAT MIT Visualise database pages in ascii code
powa powa PGDG 5.0.1 STAT PostgreSQL PostgreSQL Workload Analyser-core
pageinspect pageinspect CONTRIB 1.12 STAT PostgreSQL inspect the contents of database pages at a low level
pgrowlocks pgrowlocks CONTRIB 1.2 STAT PostgreSQL show row-level locking information
sslinfo sslinfo CONTRIB 1.2 STAT PostgreSQL information about SSL certificates
pg_buffercache pg_buffercache CONTRIB 1.5 STAT PostgreSQL examine the shared buffer cache
pg_walinspect pg_walinspect CONTRIB 1.1 STAT PostgreSQL functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap pg_freespacemap CONTRIB 1.2 STAT PostgreSQL examine the free space map (FSM)
pg_visibility pg_visibility CONTRIB 1.2 STAT PostgreSQL examine the visibility map (VM) and page-level visibility info
pgstattuple pgstattuple CONTRIB 1.5 STAT PostgreSQL show tuple-level statistics
auto_explain auto_explain CONTRIB - STAT PostgreSQL Provides a means for logging execution plans of slow statements automatically
pg_stat_statements pg_stat_statements CONTRIB 1.11 STAT PostgreSQL track planning and execution statistics of all SQL statements executed
passwordcheck_cracklib passwordcheck PIGSTY 3.0.0 SEC LGPLv2 Strengthen PostgreSQL user password checks with cracklib
supautils supautils PIGSTY 2.6.0 SEC Apache-2.0 Extension that secures a cluster on a cloud environment
pgsodium pgsodium PIGSTY 3.1.9 SEC BSD 3 Postgres extension for libsodium functions
supabase_vault pg_vault PIGSTY 0.2.8 SEC Apache-2.0 Supabase Vault Extension
pg_session_jwt pg_session_jwt PIGSTY 0.1.2 SEC Apache-2.0 Manage authentication sessions using JWTs
anon pg_anon PIGSTY 2.0.0 SEC PostgreSQL PostgreSQL Anonymizer (anon) extension
pg_tde pg_tde PIGSTY 1.0 SEC MIT pg_tde access method
pgsmcrypto pgsmcrypto PIGSTY 0.1.0 SEC MIT PostgreSQL SM Algorithm Extension
pgaudit pgaudit PGDG 17.0 SEC PostgreSQL provides auditing functionality
pgauditlogtofile pgauditlogtofile PGDG 1.6 SEC PostgreSQL pgAudit addon to redirect audit log to an independent file
pg_auth_mon pg_auth_mon PIGSTY 1.1 SEC MIT monitor connection attempts per user
credcheck credcheck PGDG 3.0.0 SEC MIT credcheck - postgresql plain text credential checker
pgcryptokey pgcryptokey PIGSTY 1.0 SEC PostgreSQL cryptographic key management
pg_jobmon pg_jobmon PIGSTY 1.4.1 SEC PostgreSQL Extension for logging and monitoring functions in PostgreSQL
logerrors logerrors PIGSTY 2.1 SEC BSD 3 Function for collecting statistics about messages in logfile
login_hook login_hook PIGSTY 1.6 SEC GPLv3 login_hook - hook to execute login_hook.login() at login time
set_user set_user PGDG 4.1.0 SEC PostgreSQL similar to SET ROLE but with added logging
pg_snakeoil pg_snakeoil PIGSTY 1 SEC PostgreSQL The PostgreSQL Antivirus
pgextwlist pgextwlist PIGSTY 1.17 SEC PostgreSQL PostgreSQL Extension Whitelisting
pg_auditor pg_auditor PIGSTY 0.2 SEC BSD 3 Audit data changes and provide flashback ability
sslutils sslutils PIGSTY 1.3 SEC PostgreSQL A Postgres extension for managing SSL certificates through SQL
noset pg_noset PIGSTY 0.3.0 SEC AGPLv3 Module for blocking SET variables for non-super users.
sepgsql sepgsql CONTRIB - SEC PostgreSQL label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay auth_delay CONTRIB - SEC PostgreSQL pause briefly before reporting authentication failure
pgcrypto pgcrypto CONTRIB 1.3 SEC PostgreSQL cryptographic functions
passwordcheck passwordcheck CONTRIB - SEC PostgreSQL checks user passwords and reject weak password
wrappers wrappers PIGSTY 0.4.4 FDW Apache-2.0 Foreign data wrappers developed by Supabase
multicorn multicorn PGDG 3.0 FDW PostgreSQL Fetch foreign data in Python in your PostgreSQL server.
odbc_fdw odbc_fdw PGDG 0.5.1 FDW PostgreSQL Foreign data wrapper for accessing remote databases using ODBC
jdbc_fdw jdbc_fdw PGDG 1.2 FDW PostgreSQL foreign-data wrapper for remote servers available over JDBC
mysql_fdw mysql_fdw PGDG 1.2 FDW BSD 3 Foreign data wrapper for querying a MySQL server
oracle_fdw oracle_fdw PGDG 1.2 FDW PostgreSQL foreign data wrapper for Oracle access
tds_fdw tds_fdw PGDG 2.0.4 FDW PostgreSQL Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
db2_fdw db2_fdw PGDG 6.0.1 FDW PostgreSQL foreign data wrapper for DB2 access
sqlite_fdw sqlite_fdw PGDG 1.1 FDW PostgreSQL SQLite Foreign Data Wrapper
pgbouncer_fdw pgbouncer_fdw PGDG 1.2.0 FDW PostgreSQL Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
mongo_fdw mongo_fdw PGDG 1.1 FDW LGPLv3 foreign data wrapper for MongoDB access
redis_fdw redis_fdw PIGSTY 1.0 FDW PostgreSQL Foreign data wrapper for querying a Redis server
redis pg_redis_pubsub PIGSTY 0.0.1 FDW MIT Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdw kafka_fdw PIGSTY 0.0.3 FDW PostgreSQL kafka Foreign Data Wrapper for CSV formatted messages
hdfs_fdw hdfs_fdw PGDG 2.0.5 FDW BSD 3 foreign-data wrapper for remote hdfs servers
firebird_fdw firebird_fdw PIGSTY 1.4.0 FDW PostgreSQL Foreign data wrapper for Firebird
aws_s3 aws_s3 PIGSTY 0.0.1 FDW Apache-2.0 aws_s3 postgres extension to import/export data from/to s3
log_fdw log_fdw PIGSTY 1.4 FDW Apache-2.0 foreign-data wrapper for Postgres log file access
sparql pgsparql PIGSTY 1.0 UTIL Apache-2.0 Query SPARQL datasource with SQL
dblink dblink CONTRIB 1.2 FDW PostgreSQL connect to other PostgreSQL databases from within a database
file_fdw file_fdw CONTRIB 1.0 FDW PostgreSQL foreign-data wrapper for flat file access
postgres_fdw postgres_fdw CONTRIB 1.1 FDW PostgreSQL foreign-data wrapper for remote PostgreSQL servers
orafce orafce PGDG 4.14 SIM BSD 0 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgtt pgtt PGDG 4.0.0 SIM ISC Extension to add Global Temporary Tables feature to PostgreSQL
session_variable session_variable PIGSTY 3.4 SIM GPLv3 Registration and manipulation of session variables and constants
pg_statement_rollback pg_statement_rollback PIGSTY 1.4 SIM ISC Server side rollback at statement level for PostgreSQL like Oracle or DB2
pg_dbms_metadata pg_dbms_metadata PGDG 1.0.0 SIM PostgreSQL Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_dbms_lock pg_dbms_lock PGDG 1.0.0 SIM PostgreSQL Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_job pg_dbms_job PGDG 1.5.0 SIM PostgreSQL Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
babelfishpg_common babelfishpg_common WILTON 3.3.3 SIM Apache-2.0 SQL Server Transact SQL Datatype Support
babelfishpg_tsql babelfishpg_tsql WILTON 3.3.1 SIM Apache-2.0 SQL Server Transact SQL compatibility
babelfishpg_tds babelfishpg_tds WILTON 1.0.0 SIM Apache-2.0 SQL Server TDS protocol extension
babelfishpg_money babelfishpg_money WILTON 1.1.0 SIM Apache-2.0 SQL Server Money Data Type
pgmemcache pgmemcache PGDG 2.3.0 SIM MIT memcached interface
pglogical pglogical PGDG 2.4.5 ETL PostgreSQL PostgreSQL Logical Replication
pglogical_origin pglogical PGDG 1.0.0 ETL PostgreSQL Dummy extension for compatibility when upgrading from Postgres 9.4
pglogical_ticker pglogical_ticker PGDG 1.4 ETL PostgreSQL Have an accurate view on pglogical replication delay
pgl_ddl_deploy pgl_ddl_deploy PGDG 2.2 ETL MIT automated ddl deployment using pglogical
pg_failover_slots pg_failover_slots PIGSTY 1.0.1 ETL PostgreSQL PG Failover Slots extension
db_migrator db_migrator PIGSTY 1.0.0 ETL BSD 3 Tools to migrate other databases to PostgreSQL
wal2json wal2json PGDG 2.5.3 ETL BSD 3 Changing data capture in JSON format
wal2mongo wal2mongo PIGSTY 1.0.7 ETL Apache-2.0 PostgreSQL logical decoding output plugin for MongoDB
decoderbufs decoderbufs PGDG 0.1.0 ETL MIT Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
decoder_raw decoder_raw PIGSTY 1.0 ETL PostgreSQL Output plugin for logical replication in Raw SQL format
pgoutput pgoutput CONTRIB - ETL PostgreSQL Logical Replication output plugin
test_decoding test_decoding CONTRIB - ETL PostgreSQL SQL-based test/example module for WAL logical decoding
mimeo mimeo PIGSTY 1.5.1 ETL PostgreSQL Extension for specialized, per-table replication between PostgreSQL instances
repmgr repmgr PGDG 5.5 ETL GPLv3 Replication manager for PostgreSQL
pg_fact_loader pg_fact_loader PGDG 2.0 ETL MIT build fact tables with Postgres
pg_bulkload pg_bulkload PIGSTY 3.1.22 ETL BSD 3 pg_bulkload is a high speed data loading utility for PostgreSQL

1 - Metadata Desc

Available Metadata for PostgreSQL Extensions, and explain each attribute.

Each extension comes with several metadata attributes. Below are the descriptions of these attributes:

  • id

    Extension identifier, an unique integer assigned to each extension for internal sorting.

  • name

    Extension name, the name of the extension in the PostgreSQL system catalog, used in CREATE EXTENSION.

    Extensions typically come with files like <name>.control, <name>*.so, and <name>*.sql.

  • alias

    Extension alias, a normalized name assigned by Pigsty to each extension, usually matching the extension name name. However, there are exceptions. For example, installing an RPM package that introduces multiple extensions will share a common alias, such as postgis.

  • version

    Default version of the extension, usually the latest version. In some special cases, the available versions in RPM and Debian may slightly differ.

  • category

    Extension category, used to distinguish the type of functionality provided by the extension, such as: gis, time, rag, fts, olap, feat, lang, type, func, admin, stat, sec, fdw, sim, etl

  • tags

    Tags describing the features of the extension.

  • repo

    The source repository of the extension, CONTRIB means it’s a PostgreSQL built-in extension, PGDG denotes a PGDG first-party extension, and PIGSTY indicates a Pigsty third-party extension.

  • lang

    The programming language used by the extension, usually C, but there are some written in C++ or Rust. There are also extensions purely composed of SQL and data.

  • need_load

    Marked with Load, meaning the extension uses PostgreSQL hooks, requiring dynamic loading and a PostgreSQL restart to take effect. Only a few extensions need dynamic loading, most are statically loaded.

  • need_ddl

    Marked with DDL, meaning the extension requires executing DDL statements: CREATE EXTENSION.

    Most extensions need the CREATE EXTENSION DDL statement for creation, but there are exceptions like pg_stat_statements and wal2json.

  • trusted

    Does installing this extension require superuser privileges? Or is the extension “trusted” — only providing functions internally within the database.

    A few extensions only provide functions internally within the database and thus do not require superuser privileges to install (trusted). Any user with CREATE privileges can install trusted extensions.

  • relocatable

    Can the extension be relocated? That is, can it be installed into other schemas? Most extensions are relocatable, but there are exceptions where extensions specify their schema explicitly.

  • schemas

    If the extension is relocatable, it can be installed into a specified schema. This attribute specifies the default schema for the extension. PostgreSQL typically allows extensions to use only one schema, but some extensions do not follow this rule, such as citus and timescaledb.

  • pg_ver

    The PostgreSQL versions supported by the extension, typically only considering versions within the support lifecycle, i.e., 12 - 16.

  • requires

    Other extensions this extension depends on, if any. An extension may depend on multiple other extensions, and these dependencies are usually declared in the requires field of the extension’s control file.

    When installing an extension, dependencies can be automatically installed with the CREATE EXTENSION xxx CASCADE statement.

  • pkg

    Extension package (RPM/DEB) name, using $v to replace the specific major PostgreSQL version number.

  • pkg_ver

    The version number of the extension package (RPM/DEB), usually consistent with the extension’s version (versionobtained from system views). However, there are rare exceptions where the package version and the extension version are inconsistent or independently managed.

  • pkg_deps

    The dependencies of the extension package (RPM/DEB), different from the extension’s dependencies (requires), here referring to the specific dependencies of the RPM/DEB package.

  • url

    The official website or source code repository of the extension.

  • license

    The open-source license used by the extension, typically PostgreSQL, MIT, Apache, GPL, etc.

  • en_desc

    The English description of the extension, describing its functions and uses.

  • zh_desc

    The Chinese description of the extension, describing its functions and uses.

  • comment

    Additional comments describing the features or considerations of the extension.

2 - RPM List

393 Available PostgreSQL Extension RPM in RHEL & Compatible Distributions

There are 393 extensions available on EL compatible systems, 13 of them are RPM exclusive, missing 7 DEB exclusive extensions.

There are 69 built-in contrib extensions, in addition to 116 rpm extensions provided by PGDG YUM repository, and 204 extensions provided by Pigsty. There are 375 extensions available in the current major version PostgreSQL 17, and 388 ready for PostgreSQL 16.

Name (Detail) Package (Repo) PackageRepo Version Category License PG Versions LOAD DDL DBSU RELOC Description
timescaledb timescaledb timescaledb-tsl_$v* PIGSTY 2.18.1 TIME Timescale 17,16,15,14 Enables scalable inserts and complex queries for time-series data
timescaledb_toolkit timescaledb_toolkit timescaledb-toolkit_$v PIGSTY 1.19.0 TIME Timescale 17,16,15,14 Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
timeseries pg_timeseries pg_timeseries_$v PIGSTY 0.1.6 TIME PostgreSQL 17,16,15,14,13 Convenience API for Tembo time series stack
periods periods periods_$v* PGDG 1.2 TIME PostgreSQL 17,16,15,14,13 Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tables temporal_tables temporal_tables_$v* PIGSTY 1.2.2 TIME BSD 2 17,16,15,14,13 temporal tables
emaj emaj e-maj_$v PGDG 4.5.0 TIME GPLv3 17,16,15,14,13 Enables fine-grained write logging and time travel on subsets of the database.
table_version table_version table_version_$v PIGSTY 1.11.1 TIME BSD 3 17,16,15,14,13 PostgreSQL table versioning extension
pg_cron pg_cron pg_cron_$v* PGDG 1.6 TIME PostgreSQL 17,16,15,14,13 Job scheduler for PostgreSQL
pg_task pg_task pg_task_$v* PGDG 1.0.0 TIME MIT 17,16,15,14,13 execute any sql command at any specific time at background
pg_later pg_later pg_later_$v PIGSTY 0.3.0 TIME PostgreSQL 17,16,15,14,13 pg_later: Run queries now and get results later
pg_background pg_background pg_background_$v* PGDG 1.3 TIME GPLv3 17,16,15,14,13 Run SQL queries in the background
postgis postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS geometry and geography spatial types and functions
postgis_topology postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS topology spatial types and functions
postgis_raster postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS raster types and functions
postgis_sfcgal postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS SFCGAL functions
postgis_tiger_geocoder postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS tiger geocoder and reverse geocoder
address_standardizer postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us postgis postgis35_$v* PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 Address Standardizer US dataset example
pgrouting pgrouting pgrouting_$v* PGDG 3.7.3 GIS GPLv2 17,16,15,14,13 pgRouting Extension
pointcloud pointcloud pointcloud_$v* PIGSTY 1.2.5 GIS BSD 3 17,16,15,14,13 data type for lidar point clouds
pointcloud_postgis pointcloud pointcloud_$v* PGDG 1.2.5 GIS BSD 3 17,16,15,14,13 integration for pointcloud LIDAR data and PostGIS geometry data
h3 pg_h3 h3-pg_$v* PGDG 4.2.2 GIS Apache-2.0 17,16,15,14,13 H3 bindings for PostgreSQL
h3_postgis pg_h3 h3-pg_$v* PGDG 4.2.2 GIS Apache-2.0 17,16,15,14,13 H3 PostGIS integration
q3c q3c q3c_$v* PIGSTY 2.0.1 GIS GPLv2 17,16,15,14,13 q3c sky indexing plugin
ogr_fdw ogr_fdw ogr_fdw_$v* PGDG 1.1 GIS MIT 17,16,15,14,13 foreign-data wrapper for GIS data access
geoip geoip geoip_$v PIGSTY 0.3.0 GIS BSD 2 17,16,15,14,13 IP-based geolocation query
pg_polyline pg_polyline pg_polyline_$v PIGSTY 0.0.1 GIS MIT 17,16,15,14,13 Fast Google Encoded Polyline encoding & decoding for postgres
pg_geohash pg_geohash pg_geohash_$v* PIGSTY 1.0 GIS MIT 17,16,15,14,13 Handle geohash based functionality for spatial coordinates
earthdistance earthdistance postgresql$v-contrib CONTRIB 1.1 GIS PostgreSQL 17,16,15,14,13 calculate great-circle distances on the surface of the Earth
vector pgvector pgvector_$v* PGDG 0.8.0 RAG PostgreSQL 17,16,15,14,13 vector data type and ivfflat and hnsw access methods
vchord vchord vchord_$v PIGSTY 0.2.0 RAG AGPLv3 17,16,15,14 Vector database plugin for Postgres, written in Rust
vectorscale pgvectorscale pgvectorscale_$v PIGSTY 0.5.1 RAG PostgreSQL 17,16,15,14,13 pgvectorscale: Advanced indexing for vector data
vectorize pg_vectorize pg_vectorize_$v PIGSTY 0.21.1 RAG PostgreSQL 17,16,15,14 The simplest way to do vector search on Postgres
pg_similarity pg_similarity pg_similarity_$v* PIGSTY 1.0 RAG BSD 3 17,16,15,14,13 support similarity queries
smlar smlar smlar_$v* PIGSTY 1.0 RAG PostgreSQL 17,16,15,14,13 Effective similarity search
pg_summarize pg_summarize pg_summarize_$v PIGSTY 0.0.1 RAG PostgreSQL 17,16,15,14,13 Text Summarization using LLMs. Built using pgrx
pg_tiktoken pg_tiktoken pg_tiktoken_$v PIGSTY 0.0.1 RAG Apache-2.0 17,16,15,14,13 pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres
pg4ml pg4ml pg4ml_$v PIGSTY 2.0 RAG AGPLv3 17,16,15,14,13 Machine learning framework for PostgreSQL
pg_search pg_search pg_search_$v PIGSTY 0.15.1 FTS AGPLv3 17,16,15,14 pg_search: Full text search for PostgreSQL using BM25
pgroonga pgroonga pgroonga_$v* PIGSTY 4.0.0 FTS PostgreSQL 17,16,15,14,13 Use Groonga as index, fast full text search platform for all languages!
pgroonga_database pgroonga pgroonga_$v* PIGSTY 4.0.0 FTS PostgreSQL 17,16,15,14,13 PGroonga database management module
pg_bigm pg_bigm pg_bigm_$v* PGDG 1.2 FTS PostgreSQL 17,16,15,14,13 create 2-gram (bigram) index for faster full text search.
zhparser zhparser zhparser_$v* PIGSTY 2.3 FTS PostgreSQL 17,16,15,14,13 a parser for full-text search of Chinese
pg_bestmatch pg_bestmatch pg_bestmatch_$v PIGSTY 0.0.1 FTS Apache-2.0 17,16,15,14,13 Generate BM25 sparse vector inside PostgreSQL
vchord_bm25 vchord_bm25 vchord_bm25_$v PIGSTY 0.1.0 FTS AGPLv3 17,16,15,14 A postgresql extension for bm25 ranking algorithm
hunspell_cs_cz hunspell_cs_cz hunspell_cs_cz_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Czech Hunspell Dictionary
hunspell_de_de hunspell_de_de hunspell_de_de_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 German Hunspell Dictionary
hunspell_en_us hunspell_en_us hunspell_en_us_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 en_US Hunspell Dictionary
hunspell_fr hunspell_fr hunspell_fr_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 French Hunspell Dictionary
hunspell_ne_np hunspell_ne_np hunspell_ne_np_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Nepali Hunspell Dictionary
hunspell_nl_nl hunspell_nl_nl hunspell_nl_nl_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Dutch Hunspell Dictionary
hunspell_nn_no hunspell_nn_no hunspell_nn_no_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Norwegian (norsk) Hunspell Dictionary
hunspell_pt_pt hunspell_pt_pt hunspell_pt_pt_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Portuguese Hunspell Dictionary
hunspell_ru_ru hunspell_ru_ru hunspell_ru_ru_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Russian Hunspell Dictionary
hunspell_ru_ru_aot hunspell_ru_ru_aot hunspell_ru_ru_aot_$v PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Russian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatch fuzzystrmatch postgresql$v-contrib CONTRIB 1.2 FTS PostgreSQL 17,16,15,14,13 determine similarities and distance between strings
pg_trgm pg_trgm postgresql$v-contrib CONTRIB 1.6 FTS PostgreSQL 17,16,15,14,13 text similarity measurement and index searching based on trigrams
citus citus citus_$v* PIGSTY 13.0.1 OLAP AGPLv3 17,16,15,14 Distributed PostgreSQL as an extension
citus_columnar citus citus_$v* PIGSTY 11.3-1 OLAP AGPLv3 17,16,15,14 Citus columnar storage engine
columnar hydra hydra_$v* PIGSTY 11.1-11 OLAP AGPLv3 16,15,14,13 Hydra Columnar extension
pg_analytics pg_analytics pg_analytics_$v PIGSTY 0.3.3 OLAP PostgreSQL 17,16,15,14 Postgres for analytics, powered by DuckDB
pg_duckdb pg_duckdb pg_duckdb_$v* PIGSTY 0.2.0 OLAP MIT 17,16,15,14 DuckDB Embedded in Postgres
pg_mooncake pg_mooncake pg_mooncake_$v* PIGSTY 0.1.0 OLAP MIT 17,16,15,14 Columnstore Table in Postgres
duckdb_fdw duckdb_fdw duckdb_fdw_$v* PIGSTY 1.1.2 OLAP MIT 17,16,15,14,13 DuckDB Foreign Data Wrapper
pg_parquet pg_parquet pg_parquet_$v PIGSTY 0.2.0 OLAP PostgreSQL 17,16,15,14 copy data between Postgres and Parquet
pg_fkpart pg_fkpart pg_fkpart_$v PIGSTY 1.7 OLAP GPLv2 17,16,15,14,13 Table partitioning by foreign key utility
pg_partman pg_partman pg_partman_$v* PGDG 5.2.4 OLAP PostgreSQL 17,16,15,14,13 Extension to manage partitioned tables by time or ID
plproxy plproxy plproxy_$v* PIGSTY 2.11.0 OLAP BSD 0 17,16,15,14,13 Database partitioning implemented as procedural language
pg_strom pg_strom pg_strom_$v* PGDG 5.1 OLAP PostgreSQL 17,16,15,14,13 PG-Strom - big-data processing acceleration using GPU and NVME
tablefunc tablefunc postgresql$v-contrib CONTRIB 1.0 OLAP PostgreSQL 17,16,15,14,13 functions that manipulate whole tables, including crosstab
omni omnigres omnigres_$v PIGSTY 0.2.4 FEAT Apache-2.0 17,16,15,14,13 Advanced adapter for Postgres extensions
omni_auth omnigres omnigres_$v PIGSTY 0.1.2 FEAT Apache-2.0 17,16,15,14,13 Basic session management
omni_aws omnigres omnigres_$v PIGSTY 0.1.2 FEAT Apache-2.0 17,16,15,14,13 Amazon Web Services APIs (S3)
omni_containers omnigres omnigres_$v PIGSTY 0.2.0 FEAT Apache-2.0 17,16,15,14,13 Docker container management
omni_credentials omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Application credential management
omni_http omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Basic HTTP types
omni_httpc omnigres omnigres_$v PIGSTY 0.1.4 FEAT Apache-2.0 17,16,15,14,13 HTTP client
omni_httpd omnigres omnigres_$v PIGSTY 0.2.9 FEAT Apache-2.0 17,16,15,14,13 HTTP server
omni_id omnigres omnigres_$v PIGSTY 0.4.0 FEAT Apache-2.0 17,16,15,14,13 Identity types
omni_json omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 JSON toolkit
omni_kube omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Kubernetes (k8s) integration
omni_ledger omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Financial ledger
omni_manifest omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Package installation manifests
omni_mimetypes omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 MIME types
omni_os omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Operating system integration
omni_polyfill omnigres omnigres_$v PIGSTY 0.2.0 FEAT Apache-2.0 17,16,15,14,13 Postgres API polyfills
omni_python omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 First-class Python support
omni_regex omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 PCRE-compatible regular expressions
omni_rest omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 REST API toolkit (with PostgREST support)
omni_schema omnigres omnigres_$v PIGSTY 0.2.3 FEAT Apache-2.0 17,16,15,14,13 Advanced schema management tooling
omni_seq omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Distributed integer sequences
omni_service omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Service management
omni_session omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Session management
omni_sql omnigres omnigres_$v PIGSTY 0.5.0 FEAT Apache-2.0 17,16,15,14,13 Programmatic SQL manipulation
omni_test omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Testing framework
omni_txn omnigres omnigres_$v PIGSTY 0.5.0 FEAT Apache-2.0 17,16,15,14,13 Transaction management
omni_types omnigres omnigres_$v PIGSTY 0.2.1 FEAT Apache-2.0 17,16,15,14,13 Advanced types
omni_var omnigres omnigres_$v PIGSTY 0.3.0 FEAT Apache-2.0 17,16,15,14,13 Scoped variables
omni_vfs omnigres omnigres_$v PIGSTY 0.2.0 FEAT Apache-2.0 17,16,15,14,13 Virtual File System
omni_vfs_types_v1 omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Virtual File System types (v1)
omni_web omnigres omnigres_$v PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Common web stack primitives
omni_xml omnigres omnigres_$v PIGSTY 0.1.2 FEAT Apache-2.0 17,16,15,14,13 XML toolkit
omni_yaml omnigres omnigres_$v PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 YAML toolkit
documentdb_core pg_documentdb_core pg_documentdb_core_$v* PIGSTY 0.100-0 FEAT MIT 17,16,15 Core API surface for DocumentDB on PostgreSQL
age age apache-age_$v* PIGSTY 1.5.0 FEAT Apache-2.0 17,16,15,14,13 AGE graph database extension
hll hll hll_$v* PGDG 2.18 FEAT Apache-2.0 17,16,15,14,13 type for storing hyperloglog data
rum rum rum_$v PGDG 1.3 FEAT PostgreSQL 17,16,15,14,13 RUM index access method
pg_graphql pg_graphql pg_graphql_$v PIGSTY 1.5.9 FEAT Apache-2.0 17,16,15,14 pg_graphql: GraphQL support
pg_jsonschema pg_jsonschema pg_jsonschema_$v PIGSTY 0.3.3 FEAT Apache-2.0 17,16,15,14,13 PostgreSQL extension providing JSON Schema validation
jsquery jsquery jsquery_$v* PGDG 1.1 FEAT PostgreSQL 17,16,15,14,13 data type for jsonb inspection
pg_hint_plan pg_hint_plan pg_hint_plan_$v* PGDG 1.7.0 FEAT BSD 3 17,16,15,14,13 Give PostgreSQL ability to manually force some decisions in execution plans.
hypopg hypopg hypopg_$v* PGDG 1.4.1 FEAT PostgreSQL 17,16,15,14,13 Hypothetical indexes for PostgreSQL
index_advisor index_advisor index_advisor_$v PIGSTY 0.2.0 FEAT PostgreSQL 17,16,15,14,13 Query index advisor
plan_filter pg_plan_filter pg_plan_filter_$v* PIGSTY 0.0.1 FEAT PostgreSQL 17,16,15,14,13 filter statements by their execution plans.
imgsmlr imgsmlr imgsmlr_$v* PIGSTY 1.0 FEAT PostgreSQL 17,16,15,14,13 Image similarity with haar
pg_ivm pg_ivm pg_ivm_$v* PGDG 1.9 FEAT PostgreSQL 17,16,15,14,13 incremental view maintenance on PostgreSQL
pg_incremental pg_incremental pg_incremental_$v* PGDG 1.1 FEAT PostgreSQL 17,16 Incremental Processing by Crunchy Data
pgmq pgmq pgmq_$v PIGSTY 1.5.0 FEAT PostgreSQL 17,16,15,14,13 A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgq pgq pgq_$v* PGDG 3.5.1 FEAT ISC 17,16,15,14,13 Generic queue for PostgreSQL
pg_cardano pg_cardano pg_cardano_$v PIGSTY 1.0.3 FEAT MIT 17,16,15,14,13 A suite of Cardano-related tools
bloom bloom postgresql$v-contrib CONTRIB 1.0 FEAT PostgreSQL 17,16,15,14,13 bloom access method - signature file based index
pg_tle pg_tle pg_tle_$v* PIGSTY 1.2.0 LANG Apache-2.0 17,16,15,14,13 Trusted Language Extensions for PostgreSQL
plv8 plv8 plv8_$v* PIGSTY 3.2.3 LANG PostgreSQL 17,16,15,14,13 PL/JavaScript (v8) trusted procedural language
pllua pllua pllua_$v* PGDG 2.0 LANG MIT 17,16,15,14,13 Lua as a procedural language
plluau pllua pllua_$v* PGDG 2.0 LANG MIT 17,16,15,14,13 Lua as an untrusted procedural language
plprql plprql plprql_$v PIGSTY 1.0.0 LANG Apache-2.0 16,15,14,13 Use PRQL in PostgreSQL - Pipelined Relational Query Language
pldbgapi pldebugger pldebugger_$v* PGDG 1.1 LANG Artistic 17,16,15,14,13 server-side support for debugging PL/pgSQL functions
plpgsql_check plpgsql_check plpgsql_check_$v* PGDG 2.7 LANG MIT 17,16,15,14,13 extended check for plpgsql functions
plprofiler plprofiler plprofiler_$v* PGDG 4.2 LANG Artistic 17,16,15,14,13 server-side support for profiling PL/pgSQL functions
plsh plsh plsh_$v* PGDG 2 LANG MIT 17,16,15,14,13 PL/sh procedural language
pljava pljava pljava_$v* PGDG 1.6.8 LANG BSD 3 17,16,15,14,13 PL/Java procedural language (https://tada.github.io/pljava/)
plr plr plr_$v* PGDG 8.4.6 LANG GPLv2 17,16,15,14,13 load R interpreter and execute R script from within a database
pgtap pgtap pgtap_$v* PGDG 1.3.3 LANG PostgreSQL 17,16,15,14,13 Unit testing for PostgreSQL
faker faker postgresql_faker_$v* PGDG 0.5.3 LANG PostgreSQL 17,16,15,14,13 Wrapper for the Faker Python library
dbt2 dbt2 dbt2-pg$v-extensions* PGDG 0.45.0 LANG Artistic 17,16,15,14,13 OSDL-DBT-2 test kit
pltcl pltcl postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/Tcl procedural language
pltclu pltcl postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/TclU untrusted procedural language
plperl plperl postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/Perl procedural language
bool_plperl plperl postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between bool and plperl
hstore_plperl plperl postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between hstore and plperl
jsonb_plperl plperl postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between jsonb and plperl
plperlu plperlu postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/PerlU untrusted procedural language
bool_plperlu plperlu postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between bool and plperlu
jsonb_plperlu plperlu postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between jsonb and plperlu
hstore_plperlu plperlu postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between hstore and plperlu
plpgsql plpgsql postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/pgSQL procedural language
plpython3u plpython3u postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/Python3U untrusted procedural language
jsonb_plpython3u plpython3u postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between jsonb and plpython3u
ltree_plpython3u plpython3u postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between ltree and plpython3u
hstore_plpython3u plpython3u postgresql$v-contrib CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between hstore and plpython3u
prefix pg_prefix prefix_$v* PGDG 1.2.0 TYPE PostgreSQL 17,16,15,14,13 Prefix Range module for PostgreSQL
semver pg_semver semver_$v* PGDG 0.32.1 TYPE PostgreSQL 17,16,15,14,13 Semantic version data type
unit pgunit postgresql-unit_$v* PGDG 7 TYPE GPLv2 17,16,15,14,13 SI units extension
pgpdf pgpdf pgpdf_$v* PIGSTY 0.1.0 TYPE GPLv3 17,16,15,14,13 PDF type with meta admin & Full-Text Search
pglite_fusion pglite_fusion pglite_fusion_$v PIGSTY 0.0.3 TYPE MIT 17,16,15,14,13 Embed an SQLite database in your PostgreSQL table
md5hash md5hash md5hash_$v* PIGSTY 1.0.1 TYPE BSD 2 17,16,15,14,13 type for storing 128-bit binary data inline
asn1oid asn1oid asn1oid_$v* PIGSTY 1 TYPE GPLv3 17,16,15,14,13 asn1oid extension
roaringbitmap roaringbitmap pg_roaringbitmap_$v* PIGSTY 0.5 TYPE Apache-2.0 17,16,15,14,13 support for Roaring Bitmaps
pgfaceting pgfaceting pgfaceting_$v PIGSTY 0.2.0 TYPE BSD 3 17,16,15,14,13 fast faceting queries using an inverted index
pg_sphere pgsphere pgsphere_$v* PIGSTY 1.5.1 TYPE BSD 3 17,16,15,14,13 spherical objects with useful functions, operators and index support
country pg_country pg_country_$v* PIGSTY 0.0.3 TYPE PostgreSQL 17,16,15,14,13 Country data type, ISO 3166-1
pg_xenophile pg_xenophile pg_xenophile_$v PIGSTY 0.8.3 TYPE PostgreSQL 17,16,15,14,13 More than the bare necessities for PostgreSQL i18n and l10n.
currency pg_currency pg_currency_$v* PIGSTY 0.0.3 TYPE MIT 17,16,15,14,13 Custom PostgreSQL currency type in 1Byte
pgmp pgmp pgmp_$v* PGDG 1.1 TYPE LGPLv3 17,16,15,14,13 Multiple Precision Arithmetic extension
numeral numeral numeral_$v* PIGSTY 1 TYPE GPLv2 17,16,15,14,13 numeral datatypes extension
pg_rational pg_rational pg_rational_$v* PIGSTY 0.0.2 TYPE MIT 17,16,15,14,13 bigint fractions
uint pguint pguint_$v* PIGSTY 0 TYPE PostgreSQL 17,16,15,14,13 unsigned integer types
uint128 pg_uint128 pg_uint128_$v* PIGSTY 1.0.0 TYPE PostgreSQL 17,16,15,14,13 Native uint128 type
hashtypes hashtypes hashtypes_$v* PIGSTY 0.1.5 TYPE PostgreSQL 17,16,15,14 sha1, md5 and other data types for PostgreSQL
ip4r ip4r ip4r_$v* PGDG 2.4 TYPE PostgreSQL 17,16,15,14,13 IPv4/v6 and IPv4/v6 range index type for PostgreSQL
pg_duration pg_duration pg_duration_$v* PIGSTY 1.0.1 TYPE MIT 17 data type for representing durations
uri pg_uri pg_uri_$v* PIGSTY 1 TYPE PostgreSQL 17,16,15,14,13 URI Data type for PostgreSQL
emailaddr pgemailaddr pg_emailaddr_$v* PIGSTY 0 TYPE PostgreSQL 17,16,15,14,13 Email address type for PostgreSQL
acl pg_acl acl_$v* PIGSTY 1.0.4 TYPE BSD 2 17,16,15,14,13 ACL Data type
timestamp9 timestamp9 timestamp9_$v* PGDG 1.4.0 TYPE MIT 17,16,15,14,13 timestamp nanosecond resolution
chkpass chkpass chkpass_$v* PIGSTY 1.0 TYPE PostgreSQL 17,16,15,14,13 data type for auto-encrypted passwords
isn isn postgresql$v-contrib CONTRIB 1.2 TYPE PostgreSQL 17,16,15,14,13 data types for international product numbering standards
seg seg postgresql$v-contrib CONTRIB 1.4 TYPE PostgreSQL 17,16,15,14,13 data type for representing line segments or floating-point intervals
cube cube postgresql$v-contrib CONTRIB 1.5 TYPE PostgreSQL 17,16,15,14,13 data type for multidimensional cubes
ltree ltree postgresql$v-contrib CONTRIB 1.3 TYPE PostgreSQL 17,16,15,14,13 data type for hierarchical tree-like structures
hstore hstore postgresql$v-contrib CONTRIB 1.8 TYPE PostgreSQL 17,16,15,14,13 data type for storing sets of (key, value) pairs
citext citext postgresql$v-contrib CONTRIB 1.6 TYPE PostgreSQL 17,16,15,14,13 data type for case-insensitive character strings
xml2 xml2 postgresql$v-contrib CONTRIB 1.1 TYPE PostgreSQL 17,16,15,14,13 XPath querying and XSLT
zstd pg_zstd pg_zstd_$v* PIGSTY 1.1.0 UTIL ISC 17,16,15,14,13 Zstandard compression algorithm implementation in PostgreSQL
gzip pg_gzip pgsql_gzip_$v* PGDG 1.0 UTIL MIT 17,16,15,14,13 gzip and gunzip functions.
http pg_http pgsql_http_$v* PGDG 1.6 UTIL MIT 17,16,15,14,13 HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net pg_net pg_net_$v* PIGSTY 0.8.0 UTIL Apache-2.0 17,16,15,14,13 Async HTTP Requests
pg_curl pg_curl pg_curl_$v* PIGSTY 2.4 UTIL MIT 17,16,15,14,13 Run curl actions for data transfer in URL syntax
pgjq pgjq pgjq_$v* PIGSTY 0.1.0 UTIL MIT 17,16,15,14 Use jq in Postgres
pgjwt pgjwt pgjwt_$v PIGSTY 0.2.0 UTIL MIT 17,16,15,14,13 JSON Web Token API for Postgresql
pg_smtp_client pg_smtp_client pg_smtp_client_$v PIGSTY 0.2.0 UTIL MIT 17,16,15,14 PostgreSQL extension to send email using SMTP
pg_html5_email_address pg_html5_email_address pg_html5_email_address_$v PIGSTY 1.2.3 UTIL PostgreSQL 17,16,15,14,13 PostgreSQL email validation that is consistent with the HTML5 spec
url_encode url_encode url_encode_$v* PIGSTY 1.2 UTIL PostgreSQL 17,16,15,14,13 url_encode, url_decode functions
pgsql_tweaks pgsql_tweaks pgsql_tweaks_$v PGDG 0.10.7 UTIL PostgreSQL 17,16,15,14,13 Some functions and views for daily usage
pg_extra_time pg_extra_time pg_extra_time_$v PGDG 2.0.0 UTIL PostgreSQL 17,16,15,14,13 Some date time functions and operators that,
pgpcre pgpcre pgpcre_$v PIGSTY 1 UTIL PostgreSQL 17,16,15,14,13 Perl Compatible Regular Expression functions
icu_ext icu_ext icu_ext_$v* PIGSTY 1.9 UTIL PostgreSQL 17,16,15,14,13 Access ICU functions
pgqr pgqr pgqr_$v* PIGSTY 1.0 UTIL BSD 3 17,16,15,14,13 QR Code generator from PostgreSQL
pg_protobuf pg_protobuf pg_protobuf_$v PIGSTY 1.0 UTIL MIT 17,16,15,14,13 Protobuf support for PostgreSQL
envvar envvar pg_envvar_$v* PIGSTY 1.0.0 UTIL PostgreSQL 17,16,15,14,13 Fetch the value of an environment variable
floatfile floatfile floatfile_$v* PIGSTY 1.3.1 UTIL MIT 17,16,15,14,13 Simple file storage for arrays of floats
pg_readme pg_readme pg_readme_$v PGDG 0.7.0 UTIL PostgreSQL 17,16,15,14,13 Generate a README.md document for a database extension or schema
ddl_historization ddl_historization ddl_historization_$v PIGSTY 0.0.7 UTIL GPLv2 17,16,15,14,13 Historize the ddl changes inside PostgreSQL database
data_historization data_historization data_historization_$v PIGSTY 1.1.0 UTIL PostgreSQL 17,16,15,14,13 PLPGSQL Script to historize data in partitionned table
schedoc pg_schedoc pg_schedoc_$v PIGSTY 0.0.2 UTIL GPLv3 17,16,15,14,13 Cross documentation between Django and DBT projects
hashlib pg_hashlib pg_hashlib_$v PIGSTY 1.1 UTIL PostgreSQL 17,16,15,14,13 Stable hash functions for Postgres
xxhash pg_xxhash pg_xxhash_$v* PIGSTY 0.0.1 UTIL BSD 2 17,16,15,14,13 xxhash functions for PostgreSQL
shacrypt shacrypt postgres_shacrypt_$v* PIGSTY 1.1 UTIL PostgreSQL 17,16,15,14,13 Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint cryptint cryptint_$v* PIGSTY 1.0.0 UTIL PostgreSQL 17,16,15,14,13 Encryption functions for int and bigint values
pguecc pg_ecdsa pg_ecdsa_$v* PIGSTY 1.0 UTIL BSD 2 17,16,15,14,13 uECC bindings for Postgres
pg_idkit pg_idkit pg_idkit_$v PIGSTY 0.2.4 FUNC Apache-2.0 17,16,15,14,13 multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7 pg_uuidv7 pg_uuidv7_$v* PGDG 1.6 FUNC MPLv2 17,16,15,14,13 pg_uuidv7: create UUIDv7 values in postgres
permuteseq permuteseq permuteseq_$v* PIGSTY 1.2 FUNC PostgreSQL 17,16,15,14,13 Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids pg_hashids pg_hashids_$v* PIGSTY 1.3 FUNC MIT 17,16,15,14,13 Short unique id generator for PostgreSQL, using hashids
sequential_uuids sequential_uuids sequential_uuids_$v PGDG 1.0.3 FUNC MIT 17,16,15,14,13 generator of sequential UUIDs
topn topn topn_$v* PGDG 2.7.0 FUNC AGPLv3 17,16,15,14,13 type for top-n JSONB
quantile quantile quantile_$v* PIGSTY 1.1.8 FUNC BSD 2 17,16,15,14,13 Quantile aggregation function
lower_quantile lower_quantile lower_quantile_$v* PIGSTY 1.0.3 FUNC BSD 2 17,16,15,14,13 Lower quantile aggregate function
count_distinct count_distinct count_distinct_$v* PIGSTY 3.0.2 FUNC BSD 2 17,16,15,14,13 An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
omnisketch omnisketch omnisketch_$v* PIGSTY 1.0.1 FUNC PostgreSQL 17,16,15,14,13 data structure for on-line agg of data into approximate sketch
ddsketch ddsketch ddsketch_$v* PIGSTY 1.0.1 FUNC PostgreSQL 17,16,15,14,13 Provides ddsketch aggregate function
vasco vasco vasco_$v* PIGSTY 0.1.0 FUNC GPLv3 17,16,15,14,13 discover hidden correlations in your data with MIC
xicor pgxicor pgxicor_$v* PIGSTY 0.1.0 FUNC GPLv3 17,16,15,14,13 XI Correlation Coefficient in Postgres
tdigest tdigest tdigest_$v* PGDG 1.4.3 FUNC Apache-2.0 17,16,15,14,13 Provides tdigest aggregate function.
first_last_agg first_last_agg first_last_agg_$v PIGSTY 0.1.4 FUNC PostgreSQL 17,16,15,14,13 first() and last() aggregate functions
extra_window_functions extra_window_functions extra_window_functions_$v* PGDG 1.0 FUNC PostgreSQL 17,16,15,14,13 Extra Window Functions for PostgreSQL
floatvec floatvec floatvec_$v* PIGSTY 1.1.1 FUNC MIT 17,16,15,14,13 Math for vectors (arrays) of numbers
aggs_for_vecs aggs_for_vecs aggs_for_vecs_$v* PIGSTY 1.3.2 FUNC MIT 17,16,15,14,13 Aggregate functions for array inputs
aggs_for_arrays aggs_for_arrays aggs_for_arrays_$v* PIGSTY 1.3.3 FUNC MIT 17,16,15,14,13 Various functions for computing statistics on arrays of numbers
arraymath pg_arraymath pg_arraymath_$v* PIGSTY 1.1 FUNC MIT 17,16,15,14,13 Array math and operators that work element by element on the contents of arrays
pg_math pg_math pg_math_$v* PIGSTY 1.0 FUNC GPLv3 17,16,15,14,13 GSL statistical functions for postgresql
random pg_random pg_random_$v* PIGSTY 2.0.0-dev FUNC PostgreSQL 17,16,15,14,13 random data generator
base36 pg_base36 pg_base36_$v* PIGSTY 1.0.0 FUNC MIT 17,16,15,14,13 Integer Base36 types
base62 pg_base62 pg_base62_$v* PIGSTY 0.0.1 FUNC MIT 17,16,15,14,13 Base62 extension for PostgreSQL
pg_base58 pg_base58 pg_base58_$v PIGSTY 0.0.1 FUNC MIT 17,16,15,14,13 Base58 Encoder/Decoder Extension for PostgreSQL
financial pg_financial pg_financial_$v* PIGSTY 1.0.1 FUNC PostgreSQL 17,16,15,14,13 Financial aggregate functions
refint refint postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for implementing referential integrity (obsolete)
autoinc autoinc postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for autoincrementing fields
insert_username insert_username postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for tracking who changed a table
moddatetime moddatetime postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for tracking last modification time
tsm_system_time tsm_system_time postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn dict_xsyn postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 text search dictionary template for extended synonym processing
tsm_system_rows tsm_system_rows postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 TABLESAMPLE method which accepts number of rows as a limit
tcn tcn postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 Triggered change notifications
uuid-ossp uuid-ossp postgresql$v-contrib CONTRIB 1.1 FUNC PostgreSQL 17,16,15,14,13 generate universally unique identifiers (UUIDs)
btree_gist btree_gist postgresql$v-contrib CONTRIB 1.7 FUNC PostgreSQL 17,16,15,14,13 support for indexing common datatypes in GiST
btree_gin btree_gin postgresql$v-contrib CONTRIB 1.3 FUNC PostgreSQL 17,16,15,14,13 support for indexing common datatypes in GIN
intarray intarray postgresql$v-contrib CONTRIB 1.5 FUNC PostgreSQL 17,16,15,14,13 functions, operators, and index support for 1-D arrays of integers
intagg intagg postgresql$v-contrib CONTRIB 1.1 FUNC PostgreSQL 17,16,15,14,13 integer aggregator and enumerator (obsolete)
dict_int dict_int postgresql$v-contrib CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 text search dictionary template for integers
unaccent unaccent postgresql$v-contrib CONTRIB 1.1 FUNC PostgreSQL 17,16,15,14,13 text search dictionary that removes accents
pg_repack pg_repack pg_repack_$v* PGDG 1.5.2 ADMIN BSD 3 17,16,15,14,13 Reorganize tables in PostgreSQL databases with minimal locks
pg_squeeze pg_squeeze pg_squeeze_$v* PGDG 1.8 ADMIN BSD 2 17,16,15,14,13 A tool to remove unused space from a relation.
pg_dirtyread pg_dirtyread pg_dirtyread_$v* PIGSTY 2 ADMIN BSD 3 17,16,15,14,13 Read dead but unvacuumed rows from table
pgfincore pgfincore pgfincore_$v* PGDG 1.3.1 ADMIN BSD 3 17,16,15,14,13 examine and manage the os buffer cache
pg_cooldown pg_cooldown pg_cooldown_$v* PIGSTY 0.1 ADMIN Apache-2.0 17,16,15,14,13 remove buffered pages for specific relations
ddlx pg_ddlx ddlx_$v PIGSTY 0.29 ADMIN PostgreSQL 17,16,15,14,13 DDL eXtractor functions
prioritize pg_prioritize pg_prioritize_$v* PGDG 1.0 ADMIN PostgreSQL 17,16,15,14,13 get and set the priority of PostgreSQL backends
pg_checksums pg_checksums pg_checksums_$v* PGDG 1.1 ADMIN BSD 2 17,16,15,14,13 Activate/deactivate/verify checksums in offline Postgres clusters
pg_readonly pg_readonly pg_readonly_$v* PGDG 1.0.0 ADMIN PostgreSQL 17,16,15,14,13 cluster database read only
pg_upless pg_upless pg_upless_$v PIGSTY 0.0.3 ADMIN PostgreSQL 17,16,15,14,13 Detect Useless UPDATE
pg_permissions pg_permissions pg_permissions_$v PGDG 1.3 ADMIN BSD 2 17,16,15,14,13 view object permissions and compare them with the desired state
pgautofailover pgautofailover pg_auto_failover_$v* PGDG 2.1 ADMIN PostgreSQL 17,16,15,14,13 pg_auto_failover
pg_catcheck pg_catcheck pg_catcheck_$v* PGDG 1.6.0 ADMIN BSD 3 17,16,15,14,13 Diagnosing system catalog corruption
pre_prepare preprepare preprepare_$v* PIGSTY 0.4 ADMIN PostgreSQL 17,16,15,14,13 Pre Prepare your Statement server side
pgcozy pgcozy pgcozy_$v PIGSTY 1.0 ADMIN PostgreSQL 17,16,15,14,13 Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphaned pg_orphaned pg_orphaned_$v* PIGSTY 1.0 ADMIN PostgreSQL 17,16,15,14,13 Deal with orphaned files
pg_crash pg_crash pg_crash_$v* PIGSTY 1.0 ADMIN BSD 3 17,16,15,14,13 Send random signals to random processes
pg_cheat_funcs pg_cheat_funcs pg_cheat_funcs_$v* PIGSTY 1.0 ADMIN PostgreSQL 17,16,15,14,13 Provides cheat (but useful) functions
fio pg_fio pg_fio_$v PIGSTY 1.0 ADMIN BSD 3 17,16,15,14,13 PostgreSQL File I/O Functions
pg_savior pg_savior pg_savior_$v* PIGSTY 0.0.1 ADMIN Apache-2.0 17,16,15,14,13 Postgres extension to save OOPS mistakes
safeupdate safeupdate safeupdate_$v* PGDG 1.4 ADMIN ISC 17,16,15,14,13 Require criteria for UPDATE and DELETE
pg_drop_events pg_drop_events pg_drop_events_$v PGDG 0.1 ADMIN PostgreSQL 17,16,15,14,13 logs transaction ids of drop table, drop column, drop materialized view statements
table_log table_log table_log_$v PIGSTY 0.6.1 ADMIN PostgreSQL 17,16,15,14,13 record table modification logs and PITR for table/row
pgagent pgagent pgagent_$v* PGDG 4.2 ADMIN PostgreSQL 17,16,15,14,13 A PostgreSQL job scheduler
pg_prewarm pg_prewarm postgresql$v-contrib CONTRIB 1.2 ADMIN PostgreSQL 17,16,15,14,13 prewarm relation data
pgpool_adm pgpool pgpool-II-pg$v-extensions PGDG 1.5 ADMIN PostgreSQL 17,16,15,14,13 Administrative functions for pgPool
pgpool_recovery pgpool pgpool-II-pg$v-extensions PGDG 1.4 ADMIN PostgreSQL 17,16,15,14,13 recovery functions for pgpool-II for V4.3
lo lo postgresql$v-contrib CONTRIB 1.1 ADMIN PostgreSQL 17,16,15,14,13 Large Object maintenance
pgpool_regclass pgpool pgpool-II-pg$v-extensions PGDG 1.0 ADMIN PostgreSQL 17,16,15,14,13 replacement for regclass
basic_archive basic_archive postgresql$v-contrib CONTRIB - ADMIN PostgreSQL 17,16,15 an example of an archive module
basebackup_to_shell basebackup_to_shell postgresql$v-contrib CONTRIB - ADMIN PostgreSQL 17,16,15 adds a custom basebackup target called shell
old_snapshot old_snapshot postgresql$v-contrib CONTRIB 1.0 ADMIN PostgreSQL 16,15,14 utilities in support of old_snapshot_threshold
adminpack adminpack postgresql$v-contrib CONTRIB 2.1 ADMIN PostgreSQL 16,15,14,13 administrative functions for PostgreSQL
amcheck amcheck postgresql$v-contrib CONTRIB 1.4 ADMIN PostgreSQL 17,16,15,14,13 functions for verifying relation integrity
pg_surgery pg_surgery postgresql$v-contrib CONTRIB 1.0 ADMIN PostgreSQL 17,16,15,14 extension to perform surgery on a damaged relation
pg_profile pg_profile pg_profile_$v* PGDG 4.8 STAT BSD 2 17,16,15,14,13 PostgreSQL load profile repository and report builder
pg_tracing pg_tracing pg_tracing_$v* PIGSTY 0.1.0 STAT MIT 17,16,15 Distributed Tracing for PostgreSQL
pg_show_plans pg_show_plans pg_show_plans_$v* PGDG 2.1 STAT PostgreSQL 17,16,15,14,13 show query plans of all currently running SQL statements
pg_stat_kcache pg_stat_kcache pg_stat_kcache_$v* PGDG 2.3.0 STAT BSD 3 17,16,15,14,13 Kernel statistics gathering
pg_stat_monitor pg_stat_monitor pg_stat_monitor_$v* PGDG 2.1 STAT BSD 3 17,16,15,14,13 The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
pg_qualstats pg_qualstats pg_qualstats_$v* PGDG 2.1.1 STAT BSD 3 17,16,15,14,13 An extension collecting statistics about quals
pg_store_plans pg_store_plans pg_store_plans_$v* PIGSTY 1.8 STAT BSD 3 17,16,15,14,13 track plan statistics of all SQL statements executed
pg_track_settings pg_track_settings pg_track_settings_$v PGDG 2.1.2 STAT PostgreSQL 17,16,15,14,13 Track settings changes
pg_wait_sampling pg_wait_sampling pg_wait_sampling_$v* PGDG 1.1 STAT PostgreSQL 17,16,15,14,13 sampling based statistics of wait events
system_stats system_stats system_stats_$v* PGDG 3.0 STAT PostgreSQL 17,16,15,14,13 EnterpriseDB system statistics for PostgreSQL
meta pg_meta pg_meta_$v PIGSTY 0.4.0 STAT BSD 2 17,16,15,14,13 Normalized, friendlier system catalog for PostgreSQL
pgnodemx pgnodemx pgnodemx_$v PIGSTY 1.7 STAT Apache-2.0 17,16,15,14,13 Capture node OS metrics via SQL queries
pg_proctab pgnodemx pgnodemx_$v PIGSTY 0.0.10-compat STAT BSD 3 17,16,15,14,13 PostgreSQL extension to access the OS process table
pg_sqlog pg_sqlog pg_sqlog_$v PIGSTY 1.6 STAT BSD 3 17,16,15,14,13 Provide SQL interface to logs
bgw_replstatus bgw_replstatus bgw_replstatus_$v* PGDG 1.0.6 STAT PostgreSQL 17,16,15,14,13 Small PostgreSQL background worker to report whether a node is a replication master or standby
pgmeminfo pgmeminfo pgmeminfo_$v* PIGSTY 1.0 STAT MIT 17,16,15,14,13 show memory usage
toastinfo toastinfo toastinfo_$v* PIGSTY 1 STAT PostgreSQL 17,16,15,14,13 show details on toasted datums
explain_ui pg_explain_ui pg_explain_ui_$v PIGSTY 0.0.1 STAT PostgreSQL 17,16,15,14,13 easily jump into a visual plan UI for any SQL query
pg_relusage pg_relusage pg_relusage_$v PIGSTY 0.0.1 STAT PostgreSQL 17,16,15,14,13 Log all the queries that reference a particular column
pagevis pagevis pagevis_$v PIGSTY 0.1 STAT MIT 17,16,15,14,13 Visualise database pages in ascii code
powa powa powa_$v* PGDG 5.0.1 STAT PostgreSQL 17,16,15,14,13 PostgreSQL Workload Analyser-core
pageinspect pageinspect postgresql$v-contrib CONTRIB 1.12 STAT PostgreSQL 17,16,15,14,13 inspect the contents of database pages at a low level
pgrowlocks pgrowlocks postgresql$v-contrib CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 show row-level locking information
sslinfo sslinfo postgresql$v-contrib CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 information about SSL certificates
pg_buffercache pg_buffercache postgresql$v-contrib CONTRIB 1.5 STAT PostgreSQL 17,16,15,14,13 examine the shared buffer cache
pg_walinspect pg_walinspect postgresql$v-contrib CONTRIB 1.1 STAT PostgreSQL 17,16,15 functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap pg_freespacemap postgresql$v-contrib CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 examine the free space map (FSM)
pg_visibility pg_visibility postgresql$v-contrib CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 examine the visibility map (VM) and page-level visibility info
pgstattuple pgstattuple postgresql$v-contrib CONTRIB 1.5 STAT PostgreSQL 17,16,15,14,13 show tuple-level statistics
auto_explain auto_explain postgresql$v-contrib CONTRIB - STAT PostgreSQL 17,16,15,14,13 Provides a means for logging execution plans of slow statements automatically
pg_stat_statements pg_stat_statements postgresql$v-contrib CONTRIB 1.11 STAT PostgreSQL 17,16,15,14,13 track planning and execution statistics of all SQL statements executed
passwordcheck_cracklib passwordcheck passwordcheck_cracklib_$v* PGDG 3.0.0 SEC LGPLv2 17,16,15,14,13 Strengthen PostgreSQL user password checks with cracklib
supautils supautils supautils_$v* PIGSTY 2.6.0 SEC Apache-2.0 17,16,15,14,13 Extension that secures a cluster on a cloud environment
pgsodium pgsodium pgsodium_$v* PIGSTY 3.1.9 SEC BSD 3 17,16,15,14,13 Postgres extension for libsodium functions
supabase_vault pg_vault vault_$v* PIGSTY 0.2.8 SEC Apache-2.0 17,16,15,14,13 Supabase Vault Extension
pg_session_jwt pg_session_jwt pg_session_jwt_$v PIGSTY 0.1.2 SEC Apache-2.0 17,16,15,14 Manage authentication sessions using JWTs
anon pg_anon pg_anon_$v PIGSTY 2.0.0 SEC PostgreSQL 17,16,15,14,13 PostgreSQL Anonymizer (anon) extension
pg_tde pg_tde pg_tde_$v* PIGSTY 1.0 SEC MIT 16 pg_tde access method
pgsmcrypto pgsmcrypto pgsmcrypto_$v PIGSTY 0.1.0 SEC MIT 17,16,15,14,13 PostgreSQL SM Algorithm Extension
pgaudit pgaudit pgaudit_$v* PGDG 17.0 SEC PostgreSQL 17,16,15,14,13 provides auditing functionality
pgauditlogtofile pgauditlogtofile pgauditlogtofile_$v* PGDG 1.6 SEC PostgreSQL 17,16,15,14,13 pgAudit addon to redirect audit log to an independent file
pg_auth_mon pg_auth_mon pg_auth_mon_$v* PGDG 1.1 SEC MIT 17,16,15,14,13 monitor connection attempts per user
credcheck credcheck credcheck_$v* PGDG 3.0.0 SEC MIT 17,16,15,14,13 credcheck - postgresql plain text credential checker
pgcryptokey pgcryptokey pgcryptokey_$v PIGSTY 1.0 SEC PostgreSQL 17,16,15,14,13 cryptographic key management
pg_jobmon pg_jobmon pg_jobmon_$v PGDG 1.4.1 SEC PostgreSQL 17,16,15,14,13 Extension for logging and monitoring functions in PostgreSQL
logerrors logerrors logerrors_$v* PGDG 2.1 SEC BSD 3 17,16,15,14,13 Function for collecting statistics about messages in logfile
login_hook login_hook login_hook_$v* PGDG 1.6 SEC GPLv3 17,16,15,14,13 login_hook - hook to execute login_hook.login() at login time
set_user set_user set_user_$v* PGDG 4.1.0 SEC PostgreSQL 17,16,15,14,13 similar to SET ROLE but with added logging
pg_snakeoil pg_snakeoil pg_snakeoil_$v* PIGSTY 1 SEC PostgreSQL 17,16,15,14,13 The PostgreSQL Antivirus
pgextwlist pgextwlist pgextwlist_$v* PIGSTY 1.17 SEC PostgreSQL 17,16,15,14,13 PostgreSQL Extension Whitelisting
pg_auditor pg_auditor pg_auditor_$v PIGSTY 0.2 SEC BSD 3 17,16,15,14,13 Audit data changes and provide flashback ability
sslutils sslutils sslutils_$v* PIGSTY 1.3 SEC PostgreSQL 17,16,15,14,13 A Postgres extension for managing SSL certificates through SQL
noset pg_noset noset_$v* PIGSTY 0.3.0 SEC AGPLv3 17,16,15,14,13 Module for blocking SET variables for non-super users.
sepgsql sepgsql postgresql$v-contrib CONTRIB - SEC PostgreSQL 17,16,15,14,13 label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay auth_delay postgresql$v-contrib CONTRIB - SEC PostgreSQL 17,16,15,14,13 pause briefly before reporting authentication failure
pgcrypto pgcrypto postgresql$v-contrib CONTRIB 1.3 SEC PostgreSQL 17,16,15,14,13 cryptographic functions
passwordcheck passwordcheck postgresql$v-contrib CONTRIB - SEC PostgreSQL 17,16,15,14,13 checks user passwords and reject weak password
wrappers wrappers wrappers_$v PIGSTY 0.4.4 FDW Apache-2.0 17,16,15,14 Foreign data wrappers developed by Supabase
multicorn multicorn multicorn2_$v* PGDG 3.0 FDW PostgreSQL 17,16,15,14,13 Fetch foreign data in Python in your PostgreSQL server.
odbc_fdw odbc_fdw odbc_fdw_$v* PGDG 0.5.1 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for accessing remote databases using ODBC
jdbc_fdw jdbc_fdw jdbc_fdw_$v* PGDG 1.2 FDW PostgreSQL 16,15,14,13 foreign-data wrapper for remote servers available over JDBC
mysql_fdw mysql_fdw mysql_fdw_$v* PGDG 1.2 FDW BSD 3 17,16,15,14,13 Foreign data wrapper for querying a MySQL server
oracle_fdw oracle_fdw oracle_fdw_$v* PGDG 1.2 FDW PostgreSQL 17,16,15,14,13 foreign data wrapper for Oracle access
tds_fdw tds_fdw tds_fdw_$v* PGDG 2.0.4 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
db2_fdw db2_fdw db2_fdw_$v* PGDG 6.0.1 FDW PostgreSQL 16,15,14,13 foreign data wrapper for DB2 access
sqlite_fdw sqlite_fdw sqlite_fdw_$v* PGDG 1.1 FDW PostgreSQL 17,16,15,14,13 SQLite Foreign Data Wrapper
pgbouncer_fdw pgbouncer_fdw pgbouncer_fdw_$v PGDG 1.2.0 FDW PostgreSQL 17,16,15,14,13 Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
mongo_fdw mongo_fdw mongo_fdw_$v* PGDG 1.1 FDW LGPLv3 16,15,14,13 foreign data wrapper for MongoDB access
redis_fdw redis_fdw redis_fdw_$v* PIGSTY 1.0 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for querying a Redis server
redis pg_redis_pubsub pg_redis_pubsub_$v* PIGSTY 0.0.1 FDW MIT 17,16,15,14,13 Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdw kafka_fdw kafka_fdw_$v PIGSTY 0.0.3 FDW PostgreSQL 16,15,14,13 kafka Foreign Data Wrapper for CSV formatted messages
hdfs_fdw hdfs_fdw hdfs_fdw_$v* PGDG 2.0.5 FDW BSD 3 17,16,15,14,13 foreign-data wrapper for remote hdfs servers
firebird_fdw firebird_fdw firebird_fdw_$v PIGSTY 1.4.0 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for Firebird
aws_s3 aws_s3 aws_s3_$v PIGSTY 0.0.1 FDW Apache-2.0 17,16,15,14,13 aws_s3 postgres extension to import/export data from/to s3
log_fdw log_fdw log_fdw_$v* PIGSTY 1.4 FDW Apache-2.0 17,16,15,14 foreign-data wrapper for Postgres log file access
sparql pgsparql pgsparql_$v PIGSTY 1.0 UTIL Apache-2.0 17,16,15,14,13 Query SPARQL datasource with SQL
dblink dblink postgresql$v-contrib CONTRIB 1.2 FDW PostgreSQL 17,16,15,14,13 connect to other PostgreSQL databases from within a database
file_fdw file_fdw postgresql$v-contrib CONTRIB 1.0 FDW PostgreSQL 17,16,15,14,13 foreign-data wrapper for flat file access
postgres_fdw postgres_fdw postgresql$v-contrib CONTRIB 1.1 FDW PostgreSQL 17,16,15,14,13 foreign-data wrapper for remote PostgreSQL servers
orafce orafce orafce_$v* PGDG 4.14 SIM BSD 0 17,16,15,14,13 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgtt pgtt pgtt_$v* PGDG 4.0.0 SIM ISC 17,16,15,14,13 Extension to add Global Temporary Tables feature to PostgreSQL
session_variable session_variable session_variable_$v* PIGSTY 3.4 SIM GPLv3 17,16,15,14,13 Registration and manipulation of session variables and constants
pg_statement_rollback pg_statement_rollback pg_statement_rollback_$v* PGDG 1.4 SIM ISC 17,16,15,14,13 Server side rollback at statement level for PostgreSQL like Oracle or DB2
pg_dbms_metadata pg_dbms_metadata pg_dbms_metadata_$v PGDG 1.0.0 SIM PostgreSQL 17,16,15,14,13 Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_dbms_lock pg_dbms_lock pg_dbms_lock_$v PGDG 1.0.0 SIM PostgreSQL 17,16,15,14,13 Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_job pg_dbms_job pg_dbms_job_$v PGDG 1.5.0 SIM PostgreSQL 17,16,15,14,13 Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
babelfishpg_common babelfishpg_common babelfishpg-common* WILTON 3.3.3 SIM Apache-2.0 15 SQL Server Transact SQL Datatype Support
babelfishpg_tsql babelfishpg_tsql babelfishpg-tsql* WILTON 3.3.1 SIM Apache-2.0 15 SQL Server Transact SQL compatibility
babelfishpg_tds babelfishpg_tds babelfishpg-tds* WILTON 1.0.0 SIM Apache-2.0 15 SQL Server TDS protocol extension
babelfishpg_money babelfishpg_money babelfishpg-money* WILTON 1.1.0 SIM Apache-2.0 15 SQL Server Money Data Type
pgmemcache pgmemcache pgmemcache_$v* PGDG 2.3.0 SIM MIT 17,16,15,14,13 memcached interface
pglogical pglogical pglogical_$v* PGDG 2.4.5 ETL PostgreSQL 17,16,15,14,13 PostgreSQL Logical Replication
pglogical_origin pglogical pglogical_$v* PGDG 1.0.0 ETL PostgreSQL 17,16,15,14,13 Dummy extension for compatibility when upgrading from Postgres 9.4
pglogical_ticker pglogical_ticker pglogical_ticker_$v* PIGSTY 1.4 ETL PostgreSQL 17,16,15,14,13 Have an accurate view on pglogical replication delay
pgl_ddl_deploy pgl_ddl_deploy pgl_ddl_deploy_$v* PGDG 2.2 ETL MIT 17,16,15,14,13 automated ddl deployment using pglogical
pg_failover_slots pg_failover_slots pg_failover_slots_$v* PIGSTY 1.0.1 ETL PostgreSQL 17,16,15,14,13 PG Failover Slots extension
db_migrator db_migrator db_migrator_$v PIGSTY 1.0.0 ETL BSD 3 17,16,15,14,13 Tools to migrate other databases to PostgreSQL
wal2json wal2json wal2json_$v* PGDG 2.5.3 ETL BSD 3 17,16,15,14,13 Changing data capture in JSON format
wal2mongo wal2mongo wal2mongo_$v* PIGSTY 1.0.7 ETL Apache-2.0 16,15,14,13 PostgreSQL logical decoding output plugin for MongoDB
decoderbufs decoderbufs postgres-decoderbufs_$v* PGDG 0.1.0 ETL MIT 17,16,15,14,13 Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
decoder_raw decoder_raw decoder_raw_$v* PIGSTY 1.0 ETL PostgreSQL 17,16,15,14,13 Output plugin for logical replication in Raw SQL format
pgoutput pgoutput postgresql$v-contrib CONTRIB - ETL PostgreSQL 17,16,15,14,13 Logical Replication output plugin
test_decoding test_decoding postgresql$v-contrib CONTRIB - ETL PostgreSQL 17,16,15,14,13 SQL-based test/example module for WAL logical decoding
mimeo mimeo mimeo_$v PIGSTY 1.5.1 ETL PostgreSQL 17,16,15,14,13 Extension for specialized, per-table replication between PostgreSQL instances
repmgr repmgr repmgr_$v* PGDG 5.5 ETL GPLv3 17,16,15,14,13 Replication manager for PostgreSQL
pg_fact_loader pg_fact_loader pg_fact_loader_$v* PGDG 2.0 ETL MIT 17,16,15,14,13 build fact tables with Postgres
pg_bulkload pg_bulkload pg_bulkload_$v* PGDG 3.1.22 ETL BSD 3 17,16,15,14,13 pg_bulkload is a high speed data loading utility for PostgreSQL

3 - DEB List

387 Available PostgreSQL Extensions Deb in Debian / Ubuntu Distributions

There are 387 extensions available on Debian compatible systems, 7 of them are DEB only, missing 13 RPM only extensions.

There are 69 built-in contrib extensions, in addition to 103 deb extensions provided by PGDG APT repository, and 211 deb extensions provided by Pigsty. There are 374 extensions available in the current major version PostgreSQL 17, and 382 ready for PostgreSQL 16.

Name (Detail) Package (Repo) PackageRepo Version Category License PG Versions LOAD DDL DBSU RELOC Description
timescaledb timescaledb postgresql-$v-timescaledb-tsl PIGSTY 2.18.1 TIME Timescale 17,16,15,14 Enables scalable inserts and complex queries for time-series data
timescaledb_toolkit timescaledb_toolkit postgresql-$v-timescaledb-toolkit PIGSTY 1.19.0 TIME Timescale 17,16,15,14 Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
timeseries pg_timeseries postgresql-$v-pg-timeseries PIGSTY 0.1.6 TIME PostgreSQL 17,16,15,14,13 Convenience API for Tembo time series stack
periods periods postgresql-$v-periods PGDG 1.2 TIME PostgreSQL 17,16,15,14,13 Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tables temporal_tables postgresql-$v-temporal-tables PIGSTY 1.2.2 TIME BSD 2 17,16,15,14,13 temporal tables
emaj emaj postgresql-$v-emaj PIGSTY 4.5.0 TIME GPLv3 17,16,15,14,13 Enables fine-grained write logging and time travel on subsets of the database.
table_version table_version postgresql-$v-tableversion PIGSTY 1.11.1 TIME BSD 3 17,16,15,14,13 PostgreSQL table versioning extension
pg_cron pg_cron postgresql-$v-cron PGDG 1.6 TIME PostgreSQL 17,16,15,14,13 Job scheduler for PostgreSQL
pg_task pg_task postgresql-$v-pg-task PIGSTY 1.0.0 TIME MIT 17,16,15,14,13 execute any sql command at any specific time at background
pg_later pg_later postgresql-$v-pg-later PIGSTY 0.3.0 TIME PostgreSQL 17,16,15,14,13 pg_later: Run queries now and get results later
pg_background pg_background postgresql-$v-pg-background PIGSTY 1.3 TIME GPLv3 17,16,15,14,13 Run SQL queries in the background
postgis postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS geometry and geography spatial types and functions
postgis_topology postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS topology spatial types and functions
postgis_raster postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS raster types and functions
postgis_sfcgal postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS SFCGAL functions
postgis_tiger_geocoder postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 PostGIS tiger geocoder and reverse geocoder
address_standardizer postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_us postgis postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts PGDG 3.5.2 GIS GPLv2 17,16,15,14,13 Address Standardizer US dataset example
pgrouting pgrouting postgresql-$v-pgrouting postgresql-$v-pgrouting-scripts PGDG 3.7.3 GIS GPLv2 17,16,15,14,13 pgRouting Extension
pointcloud pointcloud postgresql-$v-pointcloud PGDG 1.2.5 GIS BSD 3 17,16,15,14,13 data type for lidar point clouds
pointcloud_postgis pointcloud postgresql-$v-pointcloud PGDG 1.2.5 GIS BSD 3 17,16,15,14,13 integration for pointcloud LIDAR data and PostGIS geometry data
h3 pg_h3 postgresql-$v-h3 PGDG 4.2.2 GIS Apache-2.0 17,16,15,14,13 H3 bindings for PostgreSQL
h3_postgis pg_h3 postgresql-$v-h3 PGDG 4.2.2 GIS Apache-2.0 17,16,15,14,13 H3 PostGIS integration
q3c q3c postgresql-$v-q3c PGDG 2.0.1 GIS GPLv2 17,16,15,14,13 q3c sky indexing plugin
ogr_fdw ogr_fdw postgresql-$v-ogr-fdw PGDG 1.1 GIS MIT 17,16,15,14,13 foreign-data wrapper for GIS data access
geoip geoip postgresql-$v-geoip PIGSTY 0.3.0 GIS BSD 2 17,16,15,14,13 IP-based geolocation query
pg_polyline pg_polyline postgresql-$v-pg-polyline PIGSTY 0.0.1 GIS MIT 17,16,15,14,13 Fast Google Encoded Polyline encoding & decoding for postgres
pg_geohash pg_geohash postgresql-$v-pg-geohash PIGSTY 1.0 GIS MIT 17,16,15,14,13 Handle geohash based functionality for spatial coordinates
mobilitydb mobilitydb postgresql-$v-mobilitydb PGDG 1.1.1 GIS GPLv3 17,16,15,14,13 MobilityDB geospatial trajectory data management & analysis platform
earthdistance earthdistance postgresql-$v CONTRIB 1.1 GIS PostgreSQL 17,16,15,14,13 calculate great-circle distances on the surface of the Earth
vector pgvector postgresql-$v-pgvector PGDG 0.8.0 RAG PostgreSQL 17,16,15,14,13 vector data type and ivfflat and hnsw access methods
vchord vchord postgresql-$v-vchord PIGSTY 0.2.0 RAG AGPLv3 17,16,15,14 Vector database plugin for Postgres, written in Rust
vectorscale pgvectorscale postgresql-$v-pgvectorscale PIGSTY 0.5.1 RAG PostgreSQL 17,16,15,14,13 pgvectorscale: Advanced indexing for vector data
vectorize pg_vectorize postgresql-$v-pg-vectorize PIGSTY 0.21.1 RAG PostgreSQL 17,16,15,14 The simplest way to do vector search on Postgres
pg_similarity pg_similarity postgresql-$v-similarity PGDG 1.0 RAG BSD 3 17,16,15,14,13 support similarity queries
smlar smlar postgresql-$v-smlar PIGSTY 1.0 RAG PostgreSQL 17,16,15,14,13 Effective similarity search
pg_summarize pg_summarize postgresql-$v-pg-summarize PIGSTY 0.0.1 RAG PostgreSQL 17,16,15,14,13 Text Summarization using LLMs. Built using pgrx
pg_tiktoken pg_tiktoken postgresql-$v-pg-tiktoken PIGSTY 0.0.1 RAG Apache-2.0 17,16,15,14,13 pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres
pg4ml pg4ml postgresql-$v-pg4ml PIGSTY 2.0 RAG AGPLv3 17,16,15,14,13 Machine learning framework for PostgreSQL
pgml pgml postgresql-$v-pgml PIGSTY 2.10.0 RAG MIT 17,16,15,14 PostgresML: Run AL/ML workloads with SQL interface
pg_search pg_search postgresql-$v-pg-search PIGSTY 0.15.1 FTS AGPLv3 17,16,15,14 pg_search: Full text search for PostgreSQL using BM25
pgroonga pgroonga postgresql-$v-pgroonga PIGSTY 4.0.0 FTS PostgreSQL 17,16,15,14,13 Use Groonga as index, fast full text search platform for all languages!
pgroonga_database pgroonga postgresql-$v-pgroonga PIGSTY 4.0.0 FTS PostgreSQL 17,16,15,14,13 PGroonga database management module
pg_bigm pg_bigm postgresql-$v-pg-bigm PIGSTY 1.2 FTS PostgreSQL 17,16,15,14,13 create 2-gram (bigram) index for faster full text search.
zhparser zhparser postgresql-$v-zhparser PIGSTY 2.3 FTS PostgreSQL 17,16,15,14,13 a parser for full-text search of Chinese
pg_bestmatch pg_bestmatch postgresql-$v-pg-bestmatch PIGSTY 0.0.1 FTS Apache-2.0 17,16,15,14,13 Generate BM25 sparse vector inside PostgreSQL
vchord_bm25 vchord_bm25 postgresql-$v-vchord-bm25 PIGSTY 0.1.0 FTS AGPLv3 17,16,15,14 A postgresql extension for bm25 ranking algorithm
hunspell_cs_cz hunspell_cs_cz postgresql-$v-hunspell-cs-cz PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Czech Hunspell Dictionary
hunspell_de_de hunspell_de_de postgresql-$v-hunspell-de-de PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 German Hunspell Dictionary
hunspell_en_us hunspell_en_us postgresql-$v-hunspell-en-us PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 en_US Hunspell Dictionary
hunspell_fr hunspell_fr postgresql-$v-hunspell-fr PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 French Hunspell Dictionary
hunspell_ne_np hunspell_ne_np postgresql-$v-hunspell-ne-np PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Nepali Hunspell Dictionary
hunspell_nl_nl hunspell_nl_nl postgresql-$v-hunspell-nl-nl PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Dutch Hunspell Dictionary
hunspell_nn_no hunspell_nn_no postgresql-$v-hunspell-nn-no PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Norwegian (norsk) Hunspell Dictionary
hunspell_pt_pt hunspell_pt_pt postgresql-$v-hunspell-pt-pt PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Portuguese Hunspell Dictionary
hunspell_ru_ru hunspell_ru_ru postgresql-$v-hunspell-ru-ru PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Russian Hunspell Dictionary
hunspell_ru_ru_aot hunspell_ru_ru_aot postgresql-$v-hunspell-ru-ru-aot PIGSTY 1.0 FTS PostgreSQL 17,16,15,14,13 Russian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatch fuzzystrmatch postgresql-$v CONTRIB 1.2 FTS PostgreSQL 17,16,15,14,13 determine similarities and distance between strings
pg_trgm pg_trgm postgresql-$v CONTRIB 1.6 FTS PostgreSQL 17,16,15,14,13 text similarity measurement and index searching based on trigrams
citus citus postgresql-$v-citus PIGSTY 13.0.1 OLAP AGPLv3 17,16,15,14 Distributed PostgreSQL as an extension
citus_columnar citus postgresql-$v-citus PIGSTY 11.3-1 OLAP AGPLv3 17,16,15,14 Citus columnar storage engine
columnar hydra postgresql-$v-hydra PIGSTY 11.1-11 OLAP AGPLv3 16,15,14,13 Hydra Columnar extension
pg_analytics pg_analytics postgresql-$v-pg-analytics PIGSTY 0.3.3 OLAP PostgreSQL 17,16,15,14 Postgres for analytics, powered by DuckDB
pg_duckdb pg_duckdb postgresql-$v-pg-duckdb PIGSTY 0.2.0 OLAP MIT 17,16,15,14 DuckDB Embedded in Postgres
pg_mooncake pg_mooncake postgresql-$v-pg-mooncake PIGSTY 0.1.0 OLAP MIT 17,16,15,14 Columnstore Table in Postgres
duckdb_fdw duckdb_fdw postgresql-$v-duckdb-fdw PIGSTY 1.1.2 OLAP MIT 17,16,15,14,13 DuckDB Foreign Data Wrapper
pg_parquet pg_parquet postgresql-$v-pg-parquet PIGSTY 0.2.0 OLAP PostgreSQL 17,16,15,14 copy data between Postgres and Parquet
pg_fkpart pg_fkpart postgresql-$v-pg-fkpart PIGSTY 1.7 OLAP GPLv2 17,16,15,14,13 Table partitioning by foreign key utility
pg_partman pg_partman postgresql-$v-partman PGDG 5.2.4 OLAP PostgreSQL 17,16,15,14,13 Extension to manage partitioned tables by time or ID
plproxy plproxy postgresql-$v-plproxy PGDG 2.11.0 OLAP BSD 0 17,16,15,14,13 Database partitioning implemented as procedural language
tablefunc tablefunc postgresql-$v CONTRIB 1.0 OLAP PostgreSQL 17,16,15,14,13 functions that manipulate whole tables, including crosstab
omni omnigres postgresql-$v-omnigres PIGSTY 0.2.4 FEAT Apache-2.0 17,16,15,14,13 Advanced adapter for Postgres extensions
omni_auth omnigres postgresql-$v-omnigres PIGSTY 0.1.2 FEAT Apache-2.0 17,16,15,14,13 Basic session management
omni_aws omnigres postgresql-$v-omnigres PIGSTY 0.1.2 FEAT Apache-2.0 17,16,15,14,13 Amazon Web Services APIs (S3)
omni_containers omnigres postgresql-$v-omnigres PIGSTY 0.2.0 FEAT Apache-2.0 17,16,15,14,13 Docker container management
omni_credentials omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Application credential management
omni_http omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Basic HTTP types
omni_httpc omnigres postgresql-$v-omnigres PIGSTY 0.1.4 FEAT Apache-2.0 17,16,15,14,13 HTTP client
omni_httpd omnigres postgresql-$v-omnigres PIGSTY 0.2.9 FEAT Apache-2.0 17,16,15,14,13 HTTP server
omni_id omnigres postgresql-$v-omnigres PIGSTY 0.4.0 FEAT Apache-2.0 17,16,15,14,13 Identity types
omni_json omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 JSON toolkit
omni_kube omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Kubernetes (k8s) integration
omni_ledger omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Financial ledger
omni_manifest omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Package installation manifests
omni_mimetypes omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 MIME types
omni_os omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Operating system integration
omni_polyfill omnigres postgresql-$v-omnigres PIGSTY 0.2.0 FEAT Apache-2.0 17,16,15,14,13 Postgres API polyfills
omni_python omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 First-class Python support
omni_regex omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 PCRE-compatible regular expressions
omni_rest omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 REST API toolkit (with PostgREST support)
omni_schema omnigres postgresql-$v-omnigres PIGSTY 0.2.3 FEAT Apache-2.0 17,16,15,14,13 Advanced schema management tooling
omni_seq omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Distributed integer sequences
omni_service omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Service management
omni_session omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Session management
omni_sql omnigres postgresql-$v-omnigres PIGSTY 0.5.0 FEAT Apache-2.0 17,16,15,14,13 Programmatic SQL manipulation
omni_test omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Testing framework
omni_txn omnigres postgresql-$v-omnigres PIGSTY 0.5.0 FEAT Apache-2.0 17,16,15,14,13 Transaction management
omni_types omnigres postgresql-$v-omnigres PIGSTY 0.2.1 FEAT Apache-2.0 17,16,15,14,13 Advanced types
omni_var omnigres postgresql-$v-omnigres PIGSTY 0.3.0 FEAT Apache-2.0 17,16,15,14,13 Scoped variables
omni_vfs omnigres postgresql-$v-omnigres PIGSTY 0.2.0 FEAT Apache-2.0 17,16,15,14,13 Virtual File System
omni_vfs_types_v1 omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 Virtual File System types (v1)
omni_web omnigres postgresql-$v-omnigres PIGSTY 0.1.1 FEAT Apache-2.0 17,16,15,14,13 Common web stack primitives
omni_xml omnigres postgresql-$v-omnigres PIGSTY 0.1.2 FEAT Apache-2.0 17,16,15,14,13 XML toolkit
omni_yaml omnigres postgresql-$v-omnigres PIGSTY 0.1.0 FEAT Apache-2.0 17,16,15,14,13 YAML toolkit
documentdb_core pg_documentdb_core postgresql-$v-documentdb-core PIGSTY 0.100-0 FEAT MIT 17,16,15 Core API surface for DocumentDB on PostgreSQL
age age postgresql-$v-age PGDG 1.5.0 FEAT Apache-2.0 17,16,15,14,13 AGE graph database extension
hll hll postgresql-$v-hll PGDG 2.18 FEAT Apache-2.0 17,16,15,14,13 type for storing hyperloglog data
rum rum postgresql-$v-rum PGDG 1.3 FEAT PostgreSQL 17,16,15,14,13 RUM index access method
pg_graphql pg_graphql postgresql-$v-pg-graphql PIGSTY 1.5.9 FEAT Apache-2.0 17,16,15,14 pg_graphql: GraphQL support
pg_jsonschema pg_jsonschema postgresql-$v-pg-jsonschema PIGSTY 0.3.3 FEAT Apache-2.0 17,16,15,14,13 PostgreSQL extension providing JSON Schema validation
jsquery jsquery postgresql-$v-jsquery PGDG 1.1 FEAT PostgreSQL 17,16,15,14,13 data type for jsonb inspection
pg_hint_plan pg_hint_plan postgresql-$v-pg-hint-plan PGDG 1.7.0 FEAT BSD 3 17,16,15,14,13 Give PostgreSQL ability to manually force some decisions in execution plans.
hypopg hypopg postgresql-$v-hypopg PGDG 1.4.1 FEAT PostgreSQL 17,16,15,14,13 Hypothetical indexes for PostgreSQL
index_advisor index_advisor postgresql-$v-index-advisor PIGSTY 0.2.0 FEAT PostgreSQL 17,16,15,14,13 Query index advisor
plan_filter pg_plan_filter postgresql-$v-pg-plan-filter PIGSTY 0.0.1 FEAT PostgreSQL 17,16,15,14,13 filter statements by their execution plans.
imgsmlr imgsmlr postgresql-$v-imgsmlr PIGSTY 1.0 FEAT PostgreSQL 17,16,15,14,13 Image similarity with haar
pg_ivm pg_ivm postgresql-$v-pg-ivm PIGSTY 1.9 FEAT PostgreSQL 17,16,15,14,13 incremental view maintenance on PostgreSQL
pg_incremental pg_incremental postgresql-$v-pg-incremental PIGSTY 1.1 FEAT PostgreSQL 17,16 Incremental Processing by Crunchy Data
pgmq pgmq postgresql-$v-pgmq PIGSTY 1.5.0 FEAT PostgreSQL 17,16,15,14,13 A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgq pgq postgresql-$v-pgq3 PGDG 3.5.1 FEAT ISC 17,16,15,14,13 Generic queue for PostgreSQL
pg_cardano pg_cardano postgresql-$v-pg-cardano PIGSTY 1.0.3 FEAT MIT 17,16,15,14,13 A suite of Cardano-related tools
rdkit rdkit postgresql-$v-rdkit PGDG 4.3.0 FEAT BSD 3 16,15,14,13 Cheminformatics functionality for PostgreSQL.
bloom bloom postgresql-$v CONTRIB 1.0 FEAT PostgreSQL 17,16,15,14,13 bloom access method - signature file based index
pg_tle pg_tle postgresql-$v-pg-tle PIGSTY 1.2.0 LANG Apache-2.0 17,16,15,14,13 Trusted Language Extensions for PostgreSQL
plv8 plv8 postgresql-$v-plv8 PIGSTY 3.2.3 LANG PostgreSQL 17,16,15,14,13 PL/JavaScript (v8) trusted procedural language
pllua pllua postgresql-$v-pllua PGDG 2.0 LANG MIT 17,16,15,14,13 Lua as a procedural language
hstore_pllua pllua postgresql-$v-pllua PGDG 1.0 LANG MIT 17,16,15,14,13 Hstore transform for Lua
plluau pllua postgresql-$v-pllua PGDG 2.0 LANG MIT 17,16,15,14,13 Lua as an untrusted procedural language
hstore_plluau pllua postgresql-$v-pllua PGDG 1.0 LANG MIT 17,16,15,14,13 Hstore transform for untrusted Lua
plprql plprql postgresql-$v-plprql PIGSTY 1.0.0 LANG Apache-2.0 16,15,14,13 Use PRQL in PostgreSQL - Pipelined Relational Query Language
pldbgapi pldebugger postgresql-$v-pldebugger PGDG 1.1 LANG Artistic 17,16,15,14,13 server-side support for debugging PL/pgSQL functions
plpgsql_check plpgsql_check postgresql-$v-plpgsql-check PGDG 2.7 LANG MIT 17,16,15,14,13 extended check for plpgsql functions
plprofiler plprofiler postgresql-$v-plprofiler PGDG 4.2 LANG Artistic 17,16,15,14,13 server-side support for profiling PL/pgSQL functions
plsh plsh postgresql-$v-plsh PGDG 2 LANG MIT 17,16,15,14,13 PL/sh procedural language
pljava pljava postgresql-$v-pljava PGDG 1.6.8 LANG BSD 3 17,16,15,14,13 PL/Java procedural language (https://tada.github.io/pljava/)
plr plr postgresql-$v-plr PGDG 8.4.6 LANG GPLv2 17,16,15,14,13 load R interpreter and execute R script from within a database
pgtap pgtap postgresql-$v-pgtap PGDG 1.3.3 LANG PostgreSQL 17,16,15,14,13 Unit testing for PostgreSQL
pltcl pltcl postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/Tcl procedural language
pltclu pltcl postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/TclU untrusted procedural language
plperl plperl postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/Perl procedural language
bool_plperl plperl postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between bool and plperl
hstore_plperl plperl postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between hstore and plperl
jsonb_plperl plperl postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between jsonb and plperl
plperlu plperlu postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/PerlU untrusted procedural language
bool_plperlu plperlu postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between bool and plperlu
jsonb_plperlu plperlu postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between jsonb and plperlu
hstore_plperlu plperlu postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between hstore and plperlu
plpgsql plpgsql postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/pgSQL procedural language
plpython3u plpython3u postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 PL/Python3U untrusted procedural language
jsonb_plpython3u plpython3u postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between jsonb and plpython3u
ltree_plpython3u plpython3u postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between ltree and plpython3u
hstore_plpython3u plpython3u postgresql-$v CONTRIB 1.0 LANG PostgreSQL 17,16,15,14,13 transform between hstore and plpython3u
prefix pg_prefix postgresql-$v-prefix PGDG 1.2.0 TYPE PostgreSQL 17,16,15,14,13 Prefix Range module for PostgreSQL
semver pg_semver postgresql-$v-semver PGDG 0.32.1 TYPE PostgreSQL 17,16,15,14,13 Semantic version data type
unit pgunit postgresql-$v-unit PGDG 7 TYPE GPLv2 17,16,15,14,13 SI units extension
pgpdf pgpdf postgresql-$v-pgpdf PIGSTY 0.1.0 TYPE GPLv3 17,16,15,14,13 PDF type with meta admin & Full-Text Search
pglite_fusion pglite_fusion postgresql-$v-pglite-fusion PIGSTY 0.0.3 TYPE MIT 17,16,15,14,13 Embed an SQLite database in your PostgreSQL table
md5hash md5hash postgresql-$v-md5hash PIGSTY 1.0.1 TYPE BSD 2 17,16,15,14,13 type for storing 128-bit binary data inline
asn1oid asn1oid postgresql-$v-asn1oid PGDG 1 TYPE GPLv3 17,16,15,14,13 asn1oid extension
roaringbitmap roaringbitmap postgresql-$v-roaringbitmap PGDG 0.5 TYPE Apache-2.0 17,16,15,14,13 support for Roaring Bitmaps
pgfaceting pgfaceting postgresql-$v-pgfaceting PGDG 0.2.0 TYPE BSD 3 17,16,15,14,13 fast faceting queries using an inverted index
pg_sphere pgsphere postgresql-$v-pgsphere PGDG 1.5.1 TYPE BSD 3 17,16,15,14,13 spherical objects with useful functions, operators and index support
country pg_country postgresql-$v-pg-country PIGSTY 0.0.3 TYPE PostgreSQL 17,16,15,14,13 Country data type, ISO 3166-1
pg_xenophile pg_xenophile postgresql-$v-pg-xenophile PIGSTY 0.8.3 TYPE PostgreSQL 17,16,15,14,13 More than the bare necessities for PostgreSQL i18n and l10n.
currency pg_currency postgresql-$v-pg-currency PIGSTY 0.0.3 TYPE MIT 17,16,15,14,13 Custom PostgreSQL currency type in 1Byte
pgmp pgmp postgresql-$v-pgmp PGDG 1.1 TYPE LGPLv3 17,16,15,14,13 Multiple Precision Arithmetic extension
numeral numeral postgresql-$v-numeral PGDG 1 TYPE GPLv2 17,16,15,14,13 numeral datatypes extension
pg_rational pg_rational postgresql-$v-rational PGDG 0.0.2 TYPE MIT 17,16,15,14,13 bigint fractions
uint pguint postgresql-$v-pguint PIGSTY 0 TYPE PostgreSQL 17,16,15,14,13 unsigned integer types
uint128 pg_uint128 postgresql-$v-pg-uint128 PIGSTY 1.0.0 TYPE PostgreSQL 17,16,15,14,13 Native uint128 type
hashtypes hashtypes postgresql-$v-hashtypes PIGSTY 0.1.5 TYPE PostgreSQL 17,16,15,14 sha1, md5 and other data types for PostgreSQL
ip4r ip4r postgresql-$v-ip4r PGDG 2.4 TYPE PostgreSQL 17,16,15,14,13 IPv4/v6 and IPv4/v6 range index type for PostgreSQL
pg_duration pg_duration postgresql-$v-pg-duration PIGSTY 1.0.1 TYPE MIT 17 data type for representing durations
uri pg_uri postgresql-$v-pg-uri PIGSTY 1 TYPE PostgreSQL 17,16,15,14,13 URI Data type for PostgreSQL
emailaddr pgemailaddr postgresql-$v-pg-emailaddr PIGSTY 0 TYPE PostgreSQL 17,16,15,14,13 Email address type for PostgreSQL
acl pg_acl postgresql-$v-acl PIGSTY 1.0.4 TYPE BSD 2 17,16,15,14,13 ACL Data type
debversion debversion postgresql-$v-debversion PGDG 1.2 TYPE PostgreSQL 17,16,15,14,13 Debian version number data type
pg_rrule pg_rrule postgresql-$v-pg-rrule PGDG 0.2.0 TYPE MIT 17,16,15,14,13 RRULE field type for PostgreSQL
timestamp9 timestamp9 postgresql-$v-timestamp9 PIGSTY 1.4.0 TYPE MIT 17,16,15,14,13 timestamp nanosecond resolution
chkpass chkpass postgresql-$v-chkpass PIGSTY 1.0 TYPE PostgreSQL 17,16,15,14,13 data type for auto-encrypted passwords
isn isn postgresql-$v CONTRIB 1.2 TYPE PostgreSQL 17,16,15,14,13 data types for international product numbering standards
seg seg postgresql-$v CONTRIB 1.4 TYPE PostgreSQL 17,16,15,14,13 data type for representing line segments or floating-point intervals
cube cube postgresql-$v CONTRIB 1.5 TYPE PostgreSQL 17,16,15,14,13 data type for multidimensional cubes
ltree ltree postgresql-$v CONTRIB 1.3 TYPE PostgreSQL 17,16,15,14,13 data type for hierarchical tree-like structures
hstore hstore postgresql-$v CONTRIB 1.8 TYPE PostgreSQL 17,16,15,14,13 data type for storing sets of (key, value) pairs
citext citext postgresql-$v CONTRIB 1.6 TYPE PostgreSQL 17,16,15,14,13 data type for case-insensitive character strings
xml2 xml2 postgresql-$v CONTRIB 1.1 TYPE PostgreSQL 17,16,15,14,13 XPath querying and XSLT
zstd pg_zstd postgresql-$v-pg-zstd PIGSTY 1.1.0 UTIL ISC 17,16,15,14,13 Zstandard compression algorithm implementation in PostgreSQL
gzip pg_gzip postgresql-$v-gzip PIGSTY 1.0 UTIL MIT 17,16,15,14,13 gzip and gunzip functions.
http pg_http postgresql-$v-http PGDG 1.6 UTIL MIT 17,16,15,14,13 HTTP client for PostgreSQL, allows web page retrieval inside the database.
pg_net pg_net postgresql-$v-pg-net PIGSTY 0.8.0 UTIL Apache-2.0 17,16,15,14,13 Async HTTP Requests
pg_curl pg_curl postgresql-$v-pg-curl PIGSTY 2.4 UTIL MIT 17,16,15,14,13 Run curl actions for data transfer in URL syntax
pgjq pgjq postgresql-$v-pgjq PIGSTY 0.1.0 UTIL MIT 17,16,15,14 Use jq in Postgres
pgjwt pgjwt postgresql-$v-pgjwt PIGSTY 0.2.0 UTIL MIT 17,16,15,14,13 JSON Web Token API for Postgresql
pg_smtp_client pg_smtp_client postgresql-$v-pg-smtp-client PIGSTY 0.2.0 UTIL MIT 17,16,15,14 PostgreSQL extension to send email using SMTP
pg_html5_email_address pg_html5_email_address postgresql-$v-pg-html5-email-address PIGSTY 1.2.3 UTIL PostgreSQL 17,16,15,14,13 PostgreSQL email validation that is consistent with the HTML5 spec
url_encode url_encode postgresql-$v-url-encode PIGSTY 1.2 UTIL PostgreSQL 17,16,15,14,13 url_encode, url_decode functions
pgsql_tweaks pgsql_tweaks postgresql-$v-pgsql-tweaks PIGSTY 0.10.7 UTIL PostgreSQL 17,16,15,14,13 Some functions and views for daily usage
pg_extra_time pg_extra_time postgresql-$v-pg-extra-time PIGSTY 2.0.0 UTIL PostgreSQL 17,16,15,14,13 Some date time functions and operators that,
pgpcre pgpcre postgresql-$v-pgpcre PGDG 1 UTIL PostgreSQL 17,16,15,14,13 Perl Compatible Regular Expression functions
icu_ext icu_ext postgresql-$v-icu-ext PGDG 1.9 UTIL PostgreSQL 17,16,15,14,13 Access ICU functions
pgqr pgqr postgresql-$v-pgqr PIGSTY 1.0 UTIL BSD 3 17,16,15,14,13 QR Code generator from PostgreSQL
pg_protobuf pg_protobuf postgresql-$v-pg-protobuf PIGSTY 1.0 UTIL MIT 17,16,15,14,13 Protobuf support for PostgreSQL
envvar envvar postgresql-$v-pg-envvar PIGSTY 1.0.0 UTIL PostgreSQL 17,16,15,14,13 Fetch the value of an environment variable
floatfile floatfile postgresql-$v-floatfile PIGSTY 1.3.1 UTIL MIT 17,16,15,14,13 Simple file storage for arrays of floats
pg_readme pg_readme postgresql-$v-pg-readme PIGSTY 0.7.0 UTIL PostgreSQL 17,16,15,14,13 Generate a README.md document for a database extension or schema
ddl_historization ddl_historization postgresql-$v-ddl-historization PIGSTY 0.0.7 UTIL GPLv2 17,16,15,14,13 Historize the ddl changes inside PostgreSQL database
data_historization data_historization postgresql-$v-data-historization PIGSTY 1.1.0 UTIL PostgreSQL 17,16,15,14,13 PLPGSQL Script to historize data in partitionned table
schedoc pg_schedoc postgresql-$v-pg-schedoc PIGSTY 0.0.2 UTIL GPLv3 17,16,15,14,13 Cross documentation between Django and DBT projects
hashlib pg_hashlib postgresql-$v-pg-hashlib PIGSTY 1.1 UTIL PostgreSQL 17,16,15,14,13 Stable hash functions for Postgres
xxhash pg_xxhash postgresql-$v-pg-xxhash PIGSTY 0.0.1 UTIL BSD 2 17,16,15,14,13 xxhash functions for PostgreSQL
shacrypt shacrypt postgresql-$v-shacrypt PIGSTY 1.1 UTIL PostgreSQL 17,16,15,14,13 Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
cryptint cryptint postgresql-$v-cryptint PIGSTY 1.0.0 UTIL PostgreSQL 17,16,15,14,13 Encryption functions for int and bigint values
pguecc pg_ecdsa postgresql-$v-pg-ecdsa PIGSTY 1.0 UTIL BSD 2 17,16,15,14,13 uECC bindings for Postgres
pg_idkit pg_idkit postgresql-$v-pg-idkit PIGSTY 0.2.4 FUNC Apache-2.0 17,16,15,14,13 multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
pg_uuidv7 pg_uuidv7 postgresql-$v-pg-uuidv7 PIGSTY 1.6 FUNC MPLv2 17,16,15,14,13 pg_uuidv7: create UUIDv7 values in postgres
permuteseq permuteseq postgresql-$v-permuteseq PIGSTY 1.2 FUNC PostgreSQL 17,16,15,14,13 Pseudo-randomly permute sequences with a format-preserving encryption on elements
pg_hashids pg_hashids postgresql-$v-pg-hashids PIGSTY 1.3 FUNC MIT 17,16,15,14,13 Short unique id generator for PostgreSQL, using hashids
sequential_uuids sequential_uuids postgresql-$v-sequential-uuids PIGSTY 1.0.3 FUNC MIT 17,16,15,14,13 generator of sequential UUIDs
topn topn postgresql-$v-topn PIGSTY 2.7.0 FUNC AGPLv3 17,16,15,14,13 type for top-n JSONB
quantile quantile postgresql-$v-quantile PIGSTY 1.1.8 FUNC BSD 2 17,16,15,14,13 Quantile aggregation function
lower_quantile lower_quantile postgresql-$v-lower-quantile PIGSTY 1.0.3 FUNC BSD 2 17,16,15,14,13 Lower quantile aggregate function
count_distinct count_distinct postgresql-$v-count-distinct PIGSTY 3.0.2 FUNC BSD 2 17,16,15,14,13 An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
omnisketch omnisketch postgresql-$v-omnisketch PIGSTY 1.0.1 FUNC PostgreSQL 17,16,15,14,13 data structure for on-line agg of data into approximate sketch
ddsketch ddsketch postgresql-$v-ddsketch PIGSTY 1.0.1 FUNC PostgreSQL 17,16,15,14,13 Provides ddsketch aggregate function
vasco vasco postgresql-$v-vasco PIGSTY 0.1.0 FUNC GPLv3 17,16,15,14,13 discover hidden correlations in your data with MIC
xicor pgxicor postgresql-$v-pgxicor PIGSTY 0.1.0 FUNC GPLv3 17,16,15,14,13 XI Correlation Coefficient in Postgres
tdigest tdigest postgresql-$v-tdigest PGDG 1.4.3 FUNC Apache-2.0 17,16,15,14,13 Provides tdigest aggregate function.
first_last_agg first_last_agg postgresql-$v-first-last-agg PGDG 0.1.4 FUNC PostgreSQL 17,16,15,14,13 first() and last() aggregate functions
extra_window_functions extra_window_functions postgresql-$v-extra-window-functions PGDG 1.0 FUNC PostgreSQL 17,16,15,14,13 Extra Window Functions for PostgreSQL
floatvec floatvec postgresql-$v-floatvec PIGSTY 1.1.1 FUNC MIT 17,16,15,14,13 Math for vectors (arrays) of numbers
aggs_for_vecs aggs_for_vecs postgresql-$v-aggs-for-vecs PIGSTY 1.3.2 FUNC MIT 17,16,15,14,13 Aggregate functions for array inputs
aggs_for_arrays aggs_for_arrays postgresql-$v-aggs-for-arrays PIGSTY 1.3.3 FUNC MIT 17,16,15,14,13 Various functions for computing statistics on arrays of numbers
arraymath pg_arraymath postgresql-$v-pg-arraymath PIGSTY 1.1 FUNC MIT 17,16,15,14,13 Array math and operators that work element by element on the contents of arrays
pg_math pg_math postgresql-$v-pg-math PIGSTY 1.0 FUNC GPLv3 17,16,15,14,13 GSL statistical functions for postgresql
random pg_random postgresql-$v-random PIGSTY 2.0.0-dev FUNC PostgreSQL 17,16,15,14,13 random data generator
base36 pg_base36 postgresql-$v-base36 PIGSTY 1.0.0 FUNC MIT 17,16,15,14,13 Integer Base36 types
base62 pg_base62 postgresql-$v-base62 PIGSTY 0.0.1 FUNC MIT 17,16,15,14,13 Base62 extension for PostgreSQL
pg_base58 pg_base58 postgresql-$v-pg-base58 PIGSTY 0.0.1 FUNC MIT 17,16,15,14,13 Base58 Encoder/Decoder Extension for PostgreSQL
financial pg_financial postgresql-$v-pg-financial PIGSTY 1.0.1 FUNC PostgreSQL 17,16,15,14,13 Financial aggregate functions
refint refint postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for implementing referential integrity (obsolete)
autoinc autoinc postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for autoincrementing fields
insert_username insert_username postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for tracking who changed a table
moddatetime moddatetime postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 functions for tracking last modification time
tsm_system_time tsm_system_time postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn dict_xsyn postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 text search dictionary template for extended synonym processing
tsm_system_rows tsm_system_rows postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 TABLESAMPLE method which accepts number of rows as a limit
tcn tcn postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 Triggered change notifications
uuid-ossp uuid-ossp postgresql-$v CONTRIB 1.1 FUNC PostgreSQL 17,16,15,14,13 generate universally unique identifiers (UUIDs)
btree_gist btree_gist postgresql-$v CONTRIB 1.7 FUNC PostgreSQL 17,16,15,14,13 support for indexing common datatypes in GiST
btree_gin btree_gin postgresql-$v CONTRIB 1.3 FUNC PostgreSQL 17,16,15,14,13 support for indexing common datatypes in GIN
intarray intarray postgresql-$v CONTRIB 1.5 FUNC PostgreSQL 17,16,15,14,13 functions, operators, and index support for 1-D arrays of integers
intagg intagg postgresql-$v CONTRIB 1.1 FUNC PostgreSQL 17,16,15,14,13 integer aggregator and enumerator (obsolete)
dict_int dict_int postgresql-$v CONTRIB 1.0 FUNC PostgreSQL 17,16,15,14,13 text search dictionary template for integers
unaccent unaccent postgresql-$v CONTRIB 1.1 FUNC PostgreSQL 17,16,15,14,13 text search dictionary that removes accents
pg_repack pg_repack postgresql-$v-repack PGDG 1.5.2 ADMIN BSD 3 17,16,15,14,13 Reorganize tables in PostgreSQL databases with minimal locks
pg_squeeze pg_squeeze postgresql-$v-squeeze PGDG 1.8 ADMIN BSD 2 17,16,15,14,13 A tool to remove unused space from a relation.
pg_dirtyread pg_dirtyread postgresql-$v-dirtyread PGDG 2 ADMIN BSD 3 17,16,15,14,13 Read dead but unvacuumed rows from table
pgfincore pgfincore postgresql-$v-pgfincore PGDG 1.3.1 ADMIN BSD 3 17,16,15,14,13 examine and manage the os buffer cache
pg_cooldown pg_cooldown postgresql-$v-pg-cooldown PIGSTY 0.1 ADMIN Apache-2.0 17,16,15,14,13 remove buffered pages for specific relations
ddlx pg_ddlx postgresql-$v-ddlx PIGSTY 0.29 ADMIN PostgreSQL 17,16,15,14,13 DDL eXtractor functions
prioritize pg_prioritize postgresql-$v-prioritize PGDG 1.0 ADMIN PostgreSQL 17,16,15,14,13 get and set the priority of PostgreSQL backends
pg_checksums pg_checksums postgresql-$v-pg-checksums PGDG 1.1 ADMIN BSD 2 17,16,15,14,13 Activate/deactivate/verify checksums in offline Postgres clusters
pg_readonly pg_readonly postgresql-$v-pg-readonly PGDG 1.0.0 ADMIN PostgreSQL 17,16,15,14,13 cluster database read only
pg_upless pg_upless postgresql-$v-pg-upless PIGSTY 0.0.3 ADMIN PostgreSQL 17,16,15,14,13 Detect Useless UPDATE
pg_permissions pg_permissions postgresql-$v-pg-permissions PIGSTY 1.3 ADMIN BSD 2 17,16,15,14,13 view object permissions and compare them with the desired state
pgautofailover pgautofailover postgresql-$v-auto-failover PGDG 2.1 ADMIN PostgreSQL 17,16,15,14,13 pg_auto_failover
pg_catcheck pg_catcheck postgresql-$v-pg-catcheck PGDG 1.6.0 ADMIN BSD 3 17,16,15,14,13 Diagnosing system catalog corruption
pre_prepare preprepare postgresql-$v-preprepare PGDG 0.4 ADMIN PostgreSQL 17,16,15,14,13 Pre Prepare your Statement server side
pgcozy pgcozy postgresql-$v-pgcozy PIGSTY 1.0 ADMIN PostgreSQL 17,16,15,14,13 Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphaned pg_orphaned postgresql-$v-pg-orphaned PIGSTY 1.0 ADMIN PostgreSQL 17,16,15,14,13 Deal with orphaned files
pg_crash pg_crash postgresql-$v-pg-crash PIGSTY 1.0 ADMIN BSD 3 17,16,15,14,13 Send random signals to random processes
pg_cheat_funcs pg_cheat_funcs postgresql-$v-pg-cheat-funcs PIGSTY 1.0 ADMIN PostgreSQL 17,16,15,14,13 Provides cheat (but useful) functions
fio pg_fio postgresql-$v-pg-fio PIGSTY 1.0 ADMIN BSD 3 17,16,15,14,13 PostgreSQL File I/O Functions
pg_savior pg_savior postgresql-$v-pg-savior PIGSTY 0.0.1 ADMIN Apache-2.0 17,16,15,14,13 Postgres extension to save OOPS mistakes
safeupdate safeupdate postgresql-$v-pg-safeupdate PGDG 1.4 ADMIN ISC 17,16,15,14,13 Require criteria for UPDATE and DELETE
pg_drop_events pg_drop_events postgresql-$v-pg-drop-events PIGSTY 0.1 ADMIN PostgreSQL 17,16,15,14,13 logs transaction ids of drop table, drop column, drop materialized view statements
table_log table_log postgresql-$v-tablelog PGDG 0.6.1 ADMIN PostgreSQL 17,16,15,14,13 record table modification logs and PITR for table/row
pgagent pgagent pgagent PGDG 4.2 ADMIN PostgreSQL 17,16,15,14,13 A PostgreSQL job scheduler
pg_prewarm pg_prewarm postgresql-$v CONTRIB 1.2 ADMIN PostgreSQL 17,16,15,14,13 prewarm relation data
pgpool_adm pgpool postgresql-$v-pgpool2 PGDG 1.5 ADMIN PostgreSQL 17,16,15,14,13 Administrative functions for pgPool
pgpool_recovery pgpool postgresql-$v-pgpool2 PGDG 1.4 ADMIN PostgreSQL 17,16,15,14,13 recovery functions for pgpool-II for V4.3
lo lo postgresql-$v CONTRIB 1.1 ADMIN PostgreSQL 17,16,15,14,13 Large Object maintenance
pgpool_regclass pgpool postgresql-$v-pgpool2 PGDG 1.0 ADMIN PostgreSQL 17,16,15,14,13 replacement for regclass
basic_archive basic_archive postgresql-$v CONTRIB - ADMIN PostgreSQL 17,16,15 an example of an archive module
basebackup_to_shell basebackup_to_shell postgresql-$v CONTRIB - ADMIN PostgreSQL 17,16,15 adds a custom basebackup target called shell
old_snapshot old_snapshot postgresql-$v CONTRIB 1.0 ADMIN PostgreSQL 16,15,14 utilities in support of old_snapshot_threshold
adminpack adminpack postgresql-$v CONTRIB 2.1 ADMIN PostgreSQL 16,15,14,13 administrative functions for PostgreSQL
amcheck amcheck postgresql-$v CONTRIB 1.4 ADMIN PostgreSQL 17,16,15,14,13 functions for verifying relation integrity
pg_surgery pg_surgery postgresql-$v CONTRIB 1.0 ADMIN PostgreSQL 17,16,15,14 extension to perform surgery on a damaged relation
pg_profile pg_profile postgresql-$v-pg-profile PIGSTY 4.8 STAT BSD 2 17,16,15,14,13 PostgreSQL load profile repository and report builder
pg_tracing pg_tracing postgresql-$v-pg-tracing PIGSTY 0.1.0 STAT MIT 17,16,15 Distributed Tracing for PostgreSQL
pg_show_plans pg_show_plans postgresql-$v-show-plans PGDG 2.1 STAT PostgreSQL 17,16,15,14,13 show query plans of all currently running SQL statements
pg_stat_kcache pg_stat_kcache postgresql-$v-pg-stat-kcache PGDG 2.3.0 STAT BSD 3 17,16,15,14,13 Kernel statistics gathering
pg_stat_monitor pg_stat_monitor postgresql-$v-pg-stat-monitor PIGSTY 2.1 STAT BSD 3 17,16,15,14,13 The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib module pg_stat_statements. pg_stat_monitor provides aggregated statistics, client information, plan details including plan, and histogram information.
pg_qualstats pg_qualstats postgresql-$v-pg-qualstats PGDG 2.1.1 STAT BSD 3 17,16,15,14,13 An extension collecting statistics about quals
pg_store_plans pg_store_plans postgresql-$v-pg-store-plan PIGSTY 1.8 STAT BSD 3 17,16,15,14,13 track plan statistics of all SQL statements executed
pg_track_settings pg_track_settings postgresql-$v-pg-track-settings PGDG 2.1.2 STAT PostgreSQL 17,16,15,14,13 Track settings changes
pg_wait_sampling pg_wait_sampling postgresql-$v-pg-wait-sampling PGDG 1.1 STAT PostgreSQL 17,16,15,14,13 sampling based statistics of wait events
system_stats system_stats postgresql-$v-system-stats PIGSTY 3.0 STAT PostgreSQL 17,16,15,14,13 EnterpriseDB system statistics for PostgreSQL
meta pg_meta postgresql-$v-pg-meta PIGSTY 0.4.0 STAT BSD 2 17,16,15,14,13 Normalized, friendlier system catalog for PostgreSQL
pgnodemx pgnodemx postgresql-$v-pgnodemx PIGSTY 1.7 STAT Apache-2.0 17,16,15,14,13 Capture node OS metrics via SQL queries
pg_proctab pgnodemx postgresql-$v-pgnodemx PIGSTY 0.0.10-compat STAT BSD 3 17,16,15,14,13 PostgreSQL extension to access the OS process table
pg_sqlog pg_sqlog postgresql-$v-pg-sqlog PIGSTY 1.6 STAT BSD 3 17,16,15,14,13 Provide SQL interface to logs
bgw_replstatus bgw_replstatus postgresql-$v-bgw-replstatus PGDG 1.0.6 STAT PostgreSQL 17,16,15,14,13 Small PostgreSQL background worker to report whether a node is a replication master or standby
pgmeminfo pgmeminfo postgresql-$v-pgmeminfo PIGSTY 1.0 STAT MIT 17,16,15,14,13 show memory usage
toastinfo toastinfo postgresql-$v-toastinfo PIGSTY 1 STAT PostgreSQL 17,16,15,14,13 show details on toasted datums
explain_ui pg_explain_ui postgresql-$v-pg-explain-ui PIGSTY 0.0.1 STAT PostgreSQL 17,16,15,14,13 easily jump into a visual plan UI for any SQL query
pg_relusage pg_relusage postgresql-$v-pg-relusage PIGSTY 0.0.1 STAT PostgreSQL 17,16,15,14,13 Log all the queries that reference a particular column
pagevis pagevis postgresql-$v-pagevis PIGSTY 0.1 STAT MIT 17,16,15,14,13 Visualise database pages in ascii code
powa powa postgresql-$v-powa PGDG 5.0.1 STAT PostgreSQL 17,16,15,14,13 PostgreSQL Workload Analyser-core
pageinspect pageinspect postgresql-$v CONTRIB 1.12 STAT PostgreSQL 17,16,15,14,13 inspect the contents of database pages at a low level
pgrowlocks pgrowlocks postgresql-$v CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 show row-level locking information
sslinfo sslinfo postgresql-$v CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 information about SSL certificates
pg_buffercache pg_buffercache postgresql-$v CONTRIB 1.5 STAT PostgreSQL 17,16,15,14,13 examine the shared buffer cache
pg_walinspect pg_walinspect postgresql-$v CONTRIB 1.1 STAT PostgreSQL 17,16,15 functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap pg_freespacemap postgresql-$v CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 examine the free space map (FSM)
pg_visibility pg_visibility postgresql-$v CONTRIB 1.2 STAT PostgreSQL 17,16,15,14,13 examine the visibility map (VM) and page-level visibility info
pgstattuple pgstattuple postgresql-$v CONTRIB 1.5 STAT PostgreSQL 17,16,15,14,13 show tuple-level statistics
auto_explain auto_explain postgresql-$v CONTRIB - STAT PostgreSQL 17,16,15,14,13 Provides a means for logging execution plans of slow statements automatically
pg_stat_statements pg_stat_statements postgresql-$v CONTRIB 1.11 STAT PostgreSQL 17,16,15,14,13 track planning and execution statistics of all SQL statements executed
passwordcheck_cracklib passwordcheck postgresql-$v-passwordcheck-cracklib PIGSTY 3.0.0 SEC LGPLv2 17,16,15,14,13 Strengthen PostgreSQL user password checks with cracklib
supautils supautils postgresql-$v-supautils PIGSTY 2.6.0 SEC Apache-2.0 17,16,15,14,13 Extension that secures a cluster on a cloud environment
pgsodium pgsodium postgresql-$v-pgsodium PIGSTY 3.1.9 SEC BSD 3 17,16,15,14,13 Postgres extension for libsodium functions
supabase_vault pg_vault postgresql-$v-vault PIGSTY 0.2.8 SEC Apache-2.0 17,16,15,14,13 Supabase Vault Extension
pg_session_jwt pg_session_jwt postgresql-$v-pg-session-jwt PIGSTY 0.1.2 SEC Apache-2.0 17,16,15,14 Manage authentication sessions using JWTs
anon pg_anon postgresql-$v-pg-anon PIGSTY 2.0.0 SEC PostgreSQL 17,16,15,14,13 PostgreSQL Anonymizer (anon) extension
pg_tde pg_tde postgresql-$v-pg-tde PIGSTY 1.0 SEC MIT 16 pg_tde access method
pgsmcrypto pgsmcrypto postgresql-$v-pgsmcrypto PIGSTY 0.1.0 SEC MIT 17,16,15,14,13 PostgreSQL SM Algorithm Extension
pgaudit pgaudit postgresql-$v-pgaudit PGDG 17.0 SEC PostgreSQL 17,16,15,14,13 provides auditing functionality
pgauditlogtofile pgauditlogtofile postgresql-$v-pgauditlogtofile PGDG 1.6 SEC PostgreSQL 17,16,15,14,13 pgAudit addon to redirect audit log to an independent file
pg_auth_mon pg_auth_mon postgresql-$v-pg-auth-mon PIGSTY 1.1 SEC MIT 17,16,15,14,13 monitor connection attempts per user
credcheck credcheck postgresql-$v-credcheck PGDG 3.0.0 SEC MIT 17,16,15,14,13 credcheck - postgresql plain text credential checker
pgcryptokey pgcryptokey postgresql-$v-pgcryptokey PIGSTY 1.0 SEC PostgreSQL 17,16,15,14,13 cryptographic key management
pg_jobmon pg_jobmon postgresql-$v-pg-jobmon PIGSTY 1.4.1 SEC PostgreSQL 17,16,15,14,13 Extension for logging and monitoring functions in PostgreSQL
logerrors logerrors postgresql-$v-logerrors PIGSTY 2.1 SEC BSD 3 17,16,15,14,13 Function for collecting statistics about messages in logfile
login_hook login_hook postgresql-$v-login-hook PIGSTY 1.6 SEC GPLv3 17,16,15,14,13 login_hook - hook to execute login_hook.login() at login time
set_user set_user postgresql-$v-set-user PGDG 4.1.0 SEC PostgreSQL 17,16,15,14,13 similar to SET ROLE but with added logging
pg_snakeoil pg_snakeoil postgresql-$v-snakeoil PGDG 1 SEC PostgreSQL 17,16,15,14,13 The PostgreSQL Antivirus
pgextwlist pgextwlist postgresql-$v-pgextwlist PIGSTY 1.17 SEC PostgreSQL 17,16,15,14,13 PostgreSQL Extension Whitelisting
pg_auditor pg_auditor postgresql-$v-pg-auditor PIGSTY 0.2 SEC BSD 3 17,16,15,14,13 Audit data changes and provide flashback ability
sslutils sslutils postgresql-$v-sslutils PIGSTY 1.3 SEC PostgreSQL 17,16,15,14,13 A Postgres extension for managing SSL certificates through SQL
noset pg_noset postgresql-$v-noset PIGSTY 0.3.0 SEC AGPLv3 17,16,15,14,13 Module for blocking SET variables for non-super users.
sepgsql sepgsql postgresql-$v CONTRIB - SEC PostgreSQL 17,16,15,14,13 label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay auth_delay postgresql-$v CONTRIB - SEC PostgreSQL 17,16,15,14,13 pause briefly before reporting authentication failure
pgcrypto pgcrypto postgresql-$v CONTRIB 1.3 SEC PostgreSQL 17,16,15,14,13 cryptographic functions
passwordcheck passwordcheck postgresql-$v CONTRIB - SEC PostgreSQL 17,16,15,14,13 checks user passwords and reject weak password
wrappers wrappers postgresql-$v-wrappers PIGSTY 0.4.4 FDW Apache-2.0 17,16,15,14 Foreign data wrappers developed by Supabase
mysql_fdw mysql_fdw postgresql-$v-mysql-fdw PGDG 1.2 FDW BSD 3 17,16,15,14,13 Foreign data wrapper for querying a MySQL server
oracle_fdw oracle_fdw postgresql-$v-oracle-fdw PGDG 1.2 FDW PostgreSQL 17,16,15,14,13 foreign data wrapper for Oracle access
tds_fdw tds_fdw postgresql-$v-tds-fdw PGDG 2.0.4 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
sqlite_fdw sqlite_fdw postgresql-$v-sqlite-fdw PGDG 1.1 FDW PostgreSQL 17,16,15,14,13 SQLite Foreign Data Wrapper
redis_fdw redis_fdw postgresql-$v-redis-fdw PIGSTY 1.0 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for querying a Redis server
redis pg_redis_pubsub postgresql-$v-pg-redis-pubsub PIGSTY 0.0.1 FDW MIT 17,16,15,14,13 Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka_fdw kafka_fdw postgresql-$v-kafka-fdw PIGSTY 0.0.3 FDW PostgreSQL 16,15,14,13 kafka Foreign Data Wrapper for CSV formatted messages
firebird_fdw firebird_fdw postgresql-$v-firebird-fdw PIGSTY 1.4.0 FDW PostgreSQL 17,16,15,14,13 Foreign data wrapper for Firebird
aws_s3 aws_s3 postgresql-$v-aws-s3 PIGSTY 0.0.1 FDW Apache-2.0 17,16,15,14,13 aws_s3 postgres extension to import/export data from/to s3
log_fdw log_fdw postgresql-$v-log-fdw PIGSTY 1.4 FDW Apache-2.0 17,16,15,14 foreign-data wrapper for Postgres log file access
sparql pgsparql postgresql-$v-pgsparql PIGSTY 1.0 UTIL Apache-2.0 17,16,15,14,13 Query SPARQL datasource with SQL
dblink dblink postgresql-$v CONTRIB 1.2 FDW PostgreSQL 17,16,15,14,13 connect to other PostgreSQL databases from within a database
file_fdw file_fdw postgresql-$v CONTRIB 1.0 FDW PostgreSQL 17,16,15,14,13 foreign-data wrapper for flat file access
postgres_fdw postgres_fdw postgresql-$v CONTRIB 1.1 FDW PostgreSQL 17,16,15,14,13 foreign-data wrapper for remote PostgreSQL servers
orafce orafce postgresql-$v-orafce PGDG 4.14 SIM BSD 0 17,16,15,14,13 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pgtt pgtt postgresql-$v-pgtt PGDG 4.0.0 SIM ISC 17,16,15,14,13 Extension to add Global Temporary Tables feature to PostgreSQL
session_variable session_variable postgresql-$v-session-variable PIGSTY 3.4 SIM GPLv3 17,16,15,14,13 Registration and manipulation of session variables and constants
pg_statement_rollback pg_statement_rollback postgresql-$v-pg-statement-rollback PIGSTY 1.4 SIM ISC 17,16,15,14,13 Server side rollback at statement level for PostgreSQL like Oracle or DB2
babelfishpg_common babelfishpg_common babelfishpg-common WILTON 3.3.3 SIM Apache-2.0 15 SQL Server Transact SQL Datatype Support
babelfishpg_tsql babelfishpg_tsql babelfishpg-tsql WILTON 3.3.1 SIM Apache-2.0 15 SQL Server Transact SQL compatibility
babelfishpg_tds babelfishpg_tds babelfishpg-tds WILTON 1.0.0 SIM Apache-2.0 15 SQL Server TDS protocol extension
babelfishpg_money babelfishpg_money babelfishpg-money WILTON 1.1.0 SIM Apache-2.0 15 SQL Server Money Data Type
pgmemcache pgmemcache postgresql-$v-pgmemcache PGDG 2.3.0 SIM MIT 17,16,15,14,13 memcached interface
pglogical pglogical postgresql-$v-pglogical PGDG 2.4.5 ETL PostgreSQL 17,16,15,14,13 PostgreSQL Logical Replication
pglogical_origin pglogical postgresql-$v-pglogical PGDG 1.0.0 ETL PostgreSQL 17,16,15,14,13 Dummy extension for compatibility when upgrading from Postgres 9.4
pglogical_ticker pglogical_ticker postgresql-$v-pglogical-ticker PGDG 1.4 ETL PostgreSQL 17,16,15,14,13 Have an accurate view on pglogical replication delay
pgl_ddl_deploy pgl_ddl_deploy postgresql-$v-pgl-ddl-deploy PGDG 2.2 ETL MIT 17,16,15,14,13 automated ddl deployment using pglogical
pg_failover_slots pg_failover_slots postgresql-$v-pg-failover-slots PIGSTY 1.0.1 ETL PostgreSQL 17,16,15,14,13 PG Failover Slots extension
db_migrator db_migrator postgresql-$v-db-migrator PIGSTY 1.0.0 ETL BSD 3 17,16,15,14,13 Tools to migrate other databases to PostgreSQL
wal2json wal2json postgresql-$v-wal2json PGDG 2.5.3 ETL BSD 3 17,16,15,14,13 Changing data capture in JSON format
wal2mongo wal2mongo postgresql-$v-wal2mongo PIGSTY 1.0.7 ETL Apache-2.0 16,15,14,13 PostgreSQL logical decoding output plugin for MongoDB
decoderbufs decoderbufs postgresql-$v-decoderbufs PGDG 0.1.0 ETL MIT 17,16,15,14,13 Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
decoder_raw decoder_raw postgresql-$v-decoder-raw PIGSTY 1.0 ETL PostgreSQL 17,16,15,14,13 Output plugin for logical replication in Raw SQL format
pgoutput pgoutput postgresql-$v CONTRIB - ETL PostgreSQL 17,16,15,14,13 Logical Replication output plugin
test_decoding test_decoding postgresql-$v CONTRIB - ETL PostgreSQL 17,16,15,14,13 SQL-based test/example module for WAL logical decoding
mimeo mimeo postgresql-$v-mimeo PGDG 1.5.1 ETL PostgreSQL 17,16,15,14,13 Extension for specialized, per-table replication between PostgreSQL instances
repmgr repmgr postgresql-$v-repmgr PGDG 5.5 ETL GPLv3 17,16,15,14,13 Replication manager for PostgreSQL
pg_fact_loader pg_fact_loader postgresql-$v-pg-fact-loader PGDG 2.0 ETL MIT 17,16,15,14,13 build fact tables with Postgres
pg_bulkload pg_bulkload postgresql-$v-pg-bulkload PIGSTY 3.1.22 ETL BSD 3 17,16,15,14,13 pg_bulkload is a high speed data loading utility for PostgreSQL

4 - Contrib List

PostgreSQL built-in extension list

PostgreSQL comes with 69 Contrib extensions, from the PGDG repo under PostgreSQL license.

Name (Detail) Package (Repo) Version Category PG Versions LOAD DDL DBSU RELOC Description
earthdistance earthdistance 1.1 GIS 17,16,15,14,13 calculate great-circle distances on the surface of the Earth
fuzzystrmatch fuzzystrmatch 1.2 FTS 17,16,15,14,13 determine similarities and distance between strings
pg_trgm pg_trgm 1.6 FTS 17,16,15,14,13 text similarity measurement and index searching based on trigrams
tablefunc tablefunc 1.0 OLAP 17,16,15,14,13 functions that manipulate whole tables, including crosstab
bloom bloom 1.0 FEAT 17,16,15,14,13 bloom access method - signature file based index
pltcl pltcl 1.0 LANG 17,16,15,14,13 PL/Tcl procedural language
pltclu pltcl 1.0 LANG 17,16,15,14,13 PL/TclU untrusted procedural language
plperl plperl 1.0 LANG 17,16,15,14,13 PL/Perl procedural language
bool_plperl plperl 1.0 LANG 17,16,15,14,13 transform between bool and plperl
hstore_plperl plperl 1.0 LANG 17,16,15,14,13 transform between hstore and plperl
jsonb_plperl plperl 1.0 LANG 17,16,15,14,13 transform between jsonb and plperl
plperlu plperlu 1.0 LANG 17,16,15,14,13 PL/PerlU untrusted procedural language
bool_plperlu plperlu 1.0 LANG 17,16,15,14,13 transform between bool and plperlu
jsonb_plperlu plperlu 1.0 LANG 17,16,15,14,13 transform between jsonb and plperlu
hstore_plperlu plperlu 1.0 LANG 17,16,15,14,13 transform between hstore and plperlu
plpgsql plpgsql 1.0 LANG 17,16,15,14,13 PL/pgSQL procedural language
plpython3u plpython3u 1.0 LANG 17,16,15,14,13 PL/Python3U untrusted procedural language
jsonb_plpython3u plpython3u 1.0 LANG 17,16,15,14,13 transform between jsonb and plpython3u
ltree_plpython3u plpython3u 1.0 LANG 17,16,15,14,13 transform between ltree and plpython3u
hstore_plpython3u plpython3u 1.0 LANG 17,16,15,14,13 transform between hstore and plpython3u
isn isn 1.2 TYPE 17,16,15,14,13 data types for international product numbering standards
seg seg 1.4 TYPE 17,16,15,14,13 data type for representing line segments or floating-point intervals
cube cube 1.5 TYPE 17,16,15,14,13 data type for multidimensional cubes
ltree ltree 1.3 TYPE 17,16,15,14,13 data type for hierarchical tree-like structures
hstore hstore 1.8 TYPE 17,16,15,14,13 data type for storing sets of (key, value) pairs
citext citext 1.6 TYPE 17,16,15,14,13 data type for case-insensitive character strings
xml2 xml2 1.1 TYPE 17,16,15,14,13 XPath querying and XSLT
refint refint 1.0 FUNC 17,16,15,14,13 functions for implementing referential integrity (obsolete)
autoinc autoinc 1.0 FUNC 17,16,15,14,13 functions for autoincrementing fields
insert_username insert_username 1.0 FUNC 17,16,15,14,13 functions for tracking who changed a table
moddatetime moddatetime 1.0 FUNC 17,16,15,14,13 functions for tracking last modification time
tsm_system_time tsm_system_time 1.0 FUNC 17,16,15,14,13 TABLESAMPLE method which accepts time in milliseconds as a limit
dict_xsyn dict_xsyn 1.0 FUNC 17,16,15,14,13 text search dictionary template for extended synonym processing
tsm_system_rows tsm_system_rows 1.0 FUNC 17,16,15,14,13 TABLESAMPLE method which accepts number of rows as a limit
tcn tcn 1.0 FUNC 17,16,15,14,13 Triggered change notifications
uuid-ossp uuid-ossp 1.1 FUNC 17,16,15,14,13 generate universally unique identifiers (UUIDs)
btree_gist btree_gist 1.7 FUNC 17,16,15,14,13 support for indexing common datatypes in GiST
btree_gin btree_gin 1.3 FUNC 17,16,15,14,13 support for indexing common datatypes in GIN
intarray intarray 1.5 FUNC 17,16,15,14,13 functions, operators, and index support for 1-D arrays of integers
intagg intagg 1.1 FUNC 17,16,15,14,13 integer aggregator and enumerator (obsolete)
dict_int dict_int 1.0 FUNC 17,16,15,14,13 text search dictionary template for integers
unaccent unaccent 1.1 FUNC 17,16,15,14,13 text search dictionary that removes accents
pg_prewarm pg_prewarm 1.2 ADMIN 17,16,15,14,13 prewarm relation data
lo lo 1.1 ADMIN 17,16,15,14,13 Large Object maintenance
basic_archive basic_archive - ADMIN 17,16,15 an example of an archive module
basebackup_to_shell basebackup_to_shell - ADMIN 17,16,15 adds a custom basebackup target called shell
old_snapshot old_snapshot 1.0 ADMIN 16,15,14 utilities in support of old_snapshot_threshold
adminpack adminpack 2.1 ADMIN 16,15,14,13 administrative functions for PostgreSQL
amcheck amcheck 1.4 ADMIN 17,16,15,14,13 functions for verifying relation integrity
pg_surgery pg_surgery 1.0 ADMIN 17,16,15,14 extension to perform surgery on a damaged relation
pageinspect pageinspect 1.12 STAT 17,16,15,14,13 inspect the contents of database pages at a low level
pgrowlocks pgrowlocks 1.2 STAT 17,16,15,14,13 show row-level locking information
sslinfo sslinfo 1.2 STAT 17,16,15,14,13 information about SSL certificates
pg_buffercache pg_buffercache 1.5 STAT 17,16,15,14,13 examine the shared buffer cache
pg_walinspect pg_walinspect 1.1 STAT 17,16,15 functions to inspect contents of PostgreSQL Write-Ahead Log
pg_freespacemap pg_freespacemap 1.2 STAT 17,16,15,14,13 examine the free space map (FSM)
pg_visibility pg_visibility 1.2 STAT 17,16,15,14,13 examine the visibility map (VM) and page-level visibility info
pgstattuple pgstattuple 1.5 STAT 17,16,15,14,13 show tuple-level statistics
auto_explain auto_explain - STAT 17,16,15,14,13 Provides a means for logging execution plans of slow statements automatically
pg_stat_statements pg_stat_statements 1.11 STAT 17,16,15,14,13 track planning and execution statistics of all SQL statements executed
sepgsql sepgsql - SEC 17,16,15,14,13 label-based mandatory access control (MAC) based on SELinux security policy.
auth_delay auth_delay - SEC 17,16,15,14,13 pause briefly before reporting authentication failure
pgcrypto pgcrypto 1.3 SEC 17,16,15,14,13 cryptographic functions
passwordcheck passwordcheck - SEC 17,16,15,14,13 checks user passwords and reject weak password
dblink dblink 1.2 FDW 17,16,15,14,13 connect to other PostgreSQL databases from within a database
file_fdw file_fdw 1.0 FDW 17,16,15,14,13 foreign-data wrapper for flat file access
postgres_fdw postgres_fdw 1.1 FDW 17,16,15,14,13 foreign-data wrapper for remote PostgreSQL servers
pgoutput pgoutput - ETL 17,16,15,14,13 Logical Replication output plugin
test_decoding test_decoding - ETL 17,16,15,14,13 SQL-based test/example module for WAL logical decoding