Extensions
Extensions
Statistics
| Category | All | PGDG | PIGSTY | CONTRIB | MISS | PG18 | PG17 | PG16 | PG15 | PG14 | PG13 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ALL | 431 | 150 | 260 | 71 | 0 | 396 | 419 | 421 | 424 | 409 | 384 |
| EL | 425 | 144 | 260 | 71 | 6 | 385 | 412 | 415 | 418 | 406 | 380 |
| Debian | 417 | 105 | 241 | 71 | 14 | 384 | 407 | 407 | 410 | 398 | 369 |
Categories
Extensions
There are 431 available PostgreSQL extensions:
| Extension | PG Versions | Attribute | Description |
|---|---|---|---|
timescaledb
|
18 17 16 15 14 13 | --sLd--
|
Enables scalable inserts and complex queries for time-series data |
timescaledb_toolkit
|
18 17 16 15 14 13 | --s-dt-
|
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities |
timeseries
|
18 17 16 15 14 13 | ----d--
|
Convenience API for time series stack |
periods
|
18 17 16 15 14 13 | --s-d--
|
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
temporal_tables
|
18 17 16 15 14 13 | --s-d-r
|
temporal tables |
emaj
|
18 17 16 15 14 13 | --s-d--
|
Enables fine-grained write logging and time travel on subsets of the database. |
table_version
|
18 17 16 15 14 13 | --s-d--
|
PostgreSQL table versioning extension |
pg_cron
|
18 17 16 15 14 13 | --sLd--
|
Job scheduler for PostgreSQL |
pg_task
|
18 17 16 15 14 13 | --sL---
|
execute any sql command at any specific time at background |
pg_later
|
18 17 16 15 14 13 | --s-d--
|
Run queries now and get results later |
pg_background
|
18 17 16 15 14 13 | --s-d-r
|
Run SQL queries in the background |
postgis
|
18 17 16 15 14 13 | --s-d--
|
PostGIS geometry and geography spatial types and functions |
postgis_topology
|
18 17 16 15 14 13 | --s-d--
|
PostGIS topology spatial types and functions |
postgis_raster
|
18 17 16 15 14 13 | --s-d--
|
PostGIS raster types and functions |
postgis_sfcgal
|
18 17 16 15 14 13 | --s-d-r
|
PostGIS SFCGAL functions |
postgis_tiger_geocoder
|
18 17 16 15 14 13 | --s-dt-
|
PostGIS tiger geocoder and reverse geocoder |
address_standardizer
|
18 17 16 15 14 13 | --s-d-r
|
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
address_standardizer_data_us
|
18 17 16 15 14 13 | --s-d-r
|
Address Standardizer US dataset example |
pgrouting
|
18 17 16 15 14 13 | --s-d-r
|
pgRouting Extension |
pointcloud
|
18 17 16 15 14 13 | --s-d--
|
data type for lidar point clouds |
pointcloud_postgis
|
18 17 16 15 14 13 | --s-dt-
|
integration for pointcloud LIDAR data and PostGIS geometry data |
h3
|
18 17 16 15 14 13 | --s-d-r
|
H3 bindings for PostgreSQL |
h3_postgis
|
18 17 16 15 14 13 | --s-d-r
|
H3 PostGIS integration |
q3c
|
18 17 16 15 14 13 | --s-d-r
|
q3c sky indexing plugin |
ogr_fdw
|
18 17 16 15 14 13 | --s-d-r
|
foreign-data wrapper for GIS data access |
geoip
|
18 17 16 15 14 13 | --s-d--
|
IP-based geolocation query |
pg_polyline
|
18 17 16 15 14 13 | --s-dt-
|
Fast Google Encoded Polyline encoding & decoding for postgres |
pg_geohash
|
18 17 16 15 14 13 | --s-d-r
|
Handle geohash based functionality for spatial coordinates |
mobilitydb
|
18 17 16 15 14 13 | --s-d-r
|
MobilityDB geospatial trajectory data management & analysis platform |
tzf
|
18 17 16 15 14 13 | --s-d--
|
Fast lookup timezone name by GPS coordinates |
earthdistance
|
18 17 16 15 14 13 | c-s-d--
|
calculate great-circle distances on the surface of the Earth |
vector
|
18 17 16 15 14 13 | --s-d-r
|
vector data type and ivfflat and hnsw access methods |
vchord
|
18 17 16 15 14 13 | --sLd-r
|
Vector database plugin for Postgres, written in Rust |
vectorscale
|
18 17 16 15 14 13 | --s-d--
|
Advanced indexing for vector data with DiskANN |
vectorize
|
18 17 16 15 14 13 | --s-d--
|
The simplest way to do vector search on Postgres |
pg_similarity
|
18 17 16 15 14 13 | --s-d-r
|
support similarity queries |
smlar
|
18 17 16 15 14 13 | --s-d-r
|
Effective similarity search |
pg_summarize
|
18 17 16 15 14 13 | --s-d--
|
Text Summarization using LLMs. Built using pgrx |
pg_tiktoken
|
18 17 16 15 14 13 | --s-d--
|
tiktoken tokenizer for use with OpenAI models in postgres |
pg4ml
|
18 17 16 15 14 13 | ----dtr
|
Machine learning framework for PostgreSQL |
pgml
|
18 17 16 15 14 13 | --sLd--
|
Run AL/ML workloads with SQL interface |
pg_search
|
18 17 16 15 14 13 | --s-dt-
|
Full text search for PostgreSQL using BM25 |
pgroonga
|
18 17 16 15 14 13 | --s-dtr
|
Use Groonga as index, fast full text search platform for all languages! |
pgroonga_database
|
18 17 16 15 14 13 | --s-dtr
|
PGroonga database management module |
pg_bigm
|
18 17 16 15 14 13 | --s-d-r
|
create 2-gram (bigram) index for faster full text search. |
zhparser
|
18 17 16 15 14 13 | --s-d-r
|
a parser for full-text search of Chinese |
pg_bestmatch
|
18 17 16 15 14 13 | --sLd--
|
Generate BM25 sparse vector inside PostgreSQL |
vchord_bm25
|
18 17 16 15 14 13 | --sLd--
|
A postgresql extension for bm25 ranking algorithm |
pg_tokenizer
|
18 17 16 15 14 13 | --s-dt-
|
Tokenizers for full-text search |
hunspell_cs_cz
|
18 17 16 15 14 13 | ----d-r
|
Czech Hunspell Dictionary |
hunspell_de_de
|
18 17 16 15 14 13 | ----d-r
|
German Hunspell Dictionary |
hunspell_en_us
|
18 17 16 15 14 13 | ----d-r
|
en_US Hunspell Dictionary |
hunspell_fr
|
18 17 16 15 14 13 | ----d-r
|
French Hunspell Dictionary |
hunspell_ne_np
|
18 17 16 15 14 13 | ----d-r
|
Nepali Hunspell Dictionary |
hunspell_nl_nl
|
18 17 16 15 14 13 | ----d-r
|
Dutch Hunspell Dictionary |
hunspell_nn_no
|
18 17 16 15 14 13 | ----d-r
|
Norwegian (norsk) Hunspell Dictionary |
hunspell_pt_pt
|
18 17 16 15 14 13 | ----d-r
|
Portuguese Hunspell Dictionary |
hunspell_ru_ru
|
18 17 16 15 14 13 | ----d-r
|
Russian Hunspell Dictionary |
hunspell_ru_ru_aot
|
18 17 16 15 14 13 | ----d-r
|
Russian Hunspell Dictionary (from AOT.ru group) |
fuzzystrmatch
|
18 17 16 15 14 13 | c-s-dt-
|
determine similarities and distance between strings |
pg_trgm
|
18 17 16 15 14 13 | c-s-d--
|
text similarity measurement and index searching based on trigrams |
citus
|
18 17 16 15 14 13 | --sLd--
|
Distributed PostgreSQL as an extension |
citus_columnar
|
18 17 16 15 14 13 | --s-d--
|
Citus columnar storage engine |
columnar
|
18 17 16 15 14 13 | --s-d--
|
Hydra Columnar extension |
pg_analytics
|
18 17 16 15 14 13 | --s-dt-
|
Postgres for analytics, powered by DuckDB |
pg_duckdb
|
18 17 16 15 14 13 | --sLd--
|
DuckDB Embedded in Postgres |
pg_mooncake
|
18 17 16 15 14 13 | ---Ld--
|
Columnstore Table in Postgres |
duckdb_fdw
|
18 17 16 15 14 13 | --s-d-r
|
DuckDB Foreign Data Wrapper |
pg_parquet
|
18 17 16 15 14 13 | --sLdt-
|
copy data between Postgres and Parquet |
pg_fkpart
|
18 17 16 15 14 13 | ----d--
|
Table partitioning by foreign key utility |
pg_partman
|
18 17 16 15 14 13 | --s-d--
|
Extension to manage partitioned tables by time or ID |
plproxy
|
18 17 16 15 14 13 | --s-d--
|
Database partitioning implemented as procedural language |
pg_strom
|
18 17 16 15 14 13 | --s-d--
|
PG-Strom - big-data processing acceleration using GPU and NVME |
tablefunc
|
18 17 16 15 14 13 | c-s-dt-
|
functions that manipulate whole tables, including crosstab |
age
|
18 17 16 15 14 13 | --s-d--
|
AGE graph database extension |
hll
|
18 17 16 15 14 13 | --s-d--
|
type for storing hyperloglog data |
rum
|
18 17 16 15 14 13 | --s-d-r
|
RUM index access method |
pg_graphql
|
18 17 16 15 14 13 | --s-d--
|
Add in-database GraphQL support |
pg_jsonschema
|
18 17 16 15 14 13 | ----d--
|
PostgreSQL extension providing JSON Schema validation |
jsquery
|
18 17 16 15 14 13 | --s-d-r
|
data type for jsonb inspection |
pg_hint_plan
|
18 17 16 15 14 13 | --s-d--
|
Give PostgreSQL ability to manually force some decisions in execution plans. |
hypopg
|
18 17 16 15 14 13 | --s-d-r
|
Hypothetical indexes for PostgreSQL |
index_advisor
|
18 17 16 15 14 13 | ----d-r
|
Query index advisor |
plan_filter
|
18 17 16 15 14 13 | --sL---
|
filter statements by their execution plans. |
imgsmlr
|
18 17 16 15 14 13 | --s-d-r
|
Image similarity with haar |
pg_ivm
|
18 17 16 15 14 13 | --s-d--
|
incremental view maintenance on PostgreSQL |
pg_incremental
|
18 17 16 15 14 13 | --s-d--
|
Incremental Processing by Crunchy Data |
pgmq
|
18 17 16 15 14 13 | --s-dt-
|
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. |
pgq
|
18 17 16 15 14 13 | --s-d--
|
Generic queue for PostgreSQL |
orioledb
|
18 17 16 15 14 13 | --sLd-r
|
OrioleDB, the next generation transactional engine |
pg_cardano
|
18 17 16 15 14 13 | --s-d--
|
A suite of Cardano-related tools |
rdkit
|
18 17 16 15 14 13 | --s-d-r
|
Cheminformatics functionality for PostgreSQL. |
omni
|
18 17 16 15 14 13 | --sLd--
|
Advanced adapter for Postgres extensions |
omni_auth
|
18 17 16 15 14 13 | ----d--
|
Basic session management |
omni_aws
|
18 17 16 15 14 13 | ----dt-
|
Amazon Web Services APIs (S3) |
omni_cloudevents
|
18 17 16 15 14 13 | ----dt-
|
CloudEvents support |
omni_containers
|
18 17 16 15 14 13 | --s-d--
|
Docker container management |
omni_credentials
|
18 17 16 15 14 13 | ----d--
|
Application credential management |
omni_csv
|
18 17 16 15 14 13 | --s-d--
|
CSV toolkit |
omni_datasets
|
18 17 16 15 14 13 | ----d--
|
Dataset provisioning |
omni_email
|
18 17 16 15 14 13 | ----d--
|
E-mail framework |
omni_http
|
18 17 16 15 14 13 | ----d--
|
Basic HTTP types |
omni_httpc
|
18 17 16 15 14 13 | --s-d--
|
HTTP client |
omni_httpd
|
18 17 16 15 14 13 | --s-d--
|
HTTP server |
omni_id
|
18 17 16 15 14 13 | --s-d-r
|
Identity types |
omni_json
|
18 17 16 15 14 13 | ----dt-
|
JSON toolkit |
omni_kube
|
18 17 16 15 14 13 | --s-d--
|
Kubernetes (k8s) integration |
omni_ledger
|
18 17 16 15 14 13 | --s-d--
|
Financial ledger |
omni_manifest
|
18 17 16 15 14 13 | ----d--
|
Package installation manifests |
omni_mimetypes
|
18 17 16 15 14 13 | ----d--
|
MIME types |
omni_os
|
18 17 16 15 14 13 | --s-d--
|
Operating system integration |
omni_polyfill
|
18 17 16 15 14 13 | --s-d--
|
Postgres API polyfills |
omni_python
|
18 17 16 15 14 13 | --s-d--
|
First-class Python support |
omni_regex
|
18 17 16 15 14 13 | --s-d-r
|
PCRE-compatible regular expressions |
omni_rest
|
18 17 16 15 14 13 | ----d--
|
REST API toolkit (with PostgREST support) |
omni_schema
|
18 17 16 15 14 13 | ----d--
|
Advanced schema management tooling |
omni_seq
|
18 17 16 15 14 13 | --s-d--
|
Distributed integer sequences |
omni_service
|
18 17 16 15 14 13 | ----d--
|
Service management |
omni_session
|
18 17 16 15 14 13 | ----d--
|
Session management |
omni_shmem
|
18 17 16 15 14 13 | --s-d--
|
Shared Memory Management |
omni_sql
|
18 17 16 15 14 13 | --s-d--
|
Programmatic SQL manipulation |
omni_sqlite
|
18 17 16 15 14 13 | --s-d--
|
Embedded SQLite |
omni_test
|
18 17 16 15 14 13 | ----d--
|
Testing framework |
omni_txn
|
18 17 16 15 14 13 | --s-d--
|
Transaction management |
omni_types
|
18 17 16 15 14 13 | --s-d--
|
Advanced types |
omni_var
|
18 17 16 15 14 13 | --s-d--
|
Scoped variables |
omni_vfs
|
18 17 16 15 14 13 | --s-d--
|
Virtual File System |
omni_vfs_types_v1
|
18 17 16 15 14 13 | ----d--
|
Virtual File System types (v1) |
omni_web
|
18 17 16 15 14 13 | --s-d--
|
Common web stack primitives |
omni_worker
|
18 17 16 15 14 13 | --s-d--
|
Generalized worker pool |
omni_xml
|
18 17 16 15 14 13 | --s-d--
|
XML toolkit |
omni_yaml
|
18 17 16 15 14 13 | --s-d--
|
YAML toolkit |
omnisketch
|
18 17 16 15 14 13 | --s-d-r
|
data structure for on-line agg of data into approximate sketch |
bloom
|
18 17 16 15 14 13 | c-s-d--
|
bloom access method - signature file based index |
pg_tle
|
18 17 16 15 14 13 | --sLd--
|
Trusted Language Extensions for PostgreSQL |
plv8
|
18 17 16 15 14 13 | --s-d--
|
PL/JavaScript (v8) trusted procedural language |
pljs
|
18 17 16 15 14 13 | --s-d--
|
PL/JS trusted procedural language |
pllua
|
18 17 16 15 14 13 | --s-d--
|
Lua as a procedural language |
hstore_pllua
|
18 17 16 15 14 13 | --s-d-r
|
Hstore transform for Lua |
plluau
|
18 17 16 15 14 13 | --s-d--
|
Lua as an untrusted procedural language |
hstore_plluau
|
18 17 16 15 14 13 | --s-d-r
|
Hstore transform for untrusted Lua |
plprql
|
18 17 16 15 14 13 | --s-d--
|
Use PRQL in PostgreSQL - Pipelined Relational Query Language |
pldbgapi
|
18 17 16 15 14 13 | --s-d-r
|
server-side support for debugging PL/pgSQL functions |
plpgsql_check
|
18 17 16 15 14 13 | --sLd--
|
extended check for plpgsql functions |
plprofiler
|
18 17 16 15 14 13 | --s-d-r
|
server-side support for profiling PL/pgSQL functions |
plsh
|
18 17 16 15 14 13 | --s-d-r
|
PL/sh procedural language |
pljava
|
18 17 16 15 14 13 | --s-d--
|
PL/Java procedural language |
plr
|
18 17 16 15 14 13 | --s-d--
|
load R interpreter and execute R script from within a database |
plxslt
|
18 17 16 15 14 13 | --s-d-r
|
XSLT procedural language for PostgreSQL |
pgtap
|
18 17 16 15 14 13 | --s-d--
|
Unit testing for PostgreSQL |
faker
|
18 17 16 15 14 13 | --s-d--
|
Wrapper for the Faker Python library |
dbt2
|
18 17 16 15 14 13 | --s-d--
|
OSDL-DBT-2 test kit |
pltcl
|
18 17 16 15 14 13 | c-s-d--
|
PL/Tcl procedural language |
pltclu
|
18 17 16 15 14 13 | c---d--
|
PL/TclU untrusted procedural language |
plperl
|
18 17 16 15 14 13 | c-s-d--
|
PL/Perl procedural language |
bool_plperl
|
18 17 16 15 14 13 | c-s-d--
|
transform between bool and plperl |
hstore_plperl
|
18 17 16 15 14 13 | c-s-d--
|
transform between hstore and plperl |
jsonb_plperl
|
18 17 16 15 14 13 | c---d--
|
transform between jsonb and plperl |
plperlu
|
18 17 16 15 14 13 | c-s-d--
|
PL/PerlU untrusted procedural language |
bool_plperlu
|
18 17 16 15 14 13 | c---d--
|
transform between bool and plperlu |
jsonb_plperlu
|
18 17 16 15 14 13 | c---d--
|
transform between jsonb and plperlu |
hstore_plperlu
|
18 17 16 15 14 13 | c---d--
|
transform between hstore and plperlu |
plpgsql
|
18 17 16 15 14 13 | c-s-d--
|
PL/pgSQL procedural language |
plpython3u
|
18 17 16 15 14 13 | c-s-d--
|
PL/Python3U untrusted procedural language |
jsonb_plpython3u
|
18 17 16 15 14 13 | c---d-r
|
transform between jsonb and plpython3u |
ltree_plpython3u
|
18 17 16 15 14 13 | c-s-d-r
|
transform between ltree and plpython3u |
hstore_plpython3u
|
18 17 16 15 14 13 | c---d-r
|
transform between hstore and plpython3u |
prefix
|
18 17 16 15 14 13 | --s-d-r
|
Prefix Range module for PostgreSQL |
semver
|
18 17 16 15 14 13 | --s-d-r
|
Semantic version data type |
unit
|
18 17 16 15 14 13 | --s-d--
|
SI units extension |
pgpdf
|
18 17 16 15 14 13 | --sLdtr
|
PDF type with meta admin & Full-Text Search |
pglite_fusion
|
18 17 16 15 14 13 | --sLd--
|
Embed an SQLite database in your PostgreSQL table |
md5hash
|
18 17 16 15 14 13 | --s-d-r
|
type for storing 128-bit binary data inline |
asn1oid
|
18 17 16 15 14 13 | --s-d-r
|
asn1oid extension |
roaringbitmap
|
18 17 16 15 14 13 | --s-d-r
|
support for Roaring Bitmaps |
pgfaceting
|
18 17 16 15 14 13 | ----dt-
|
fast faceting queries using an inverted index |
pg_sphere
|
18 17 16 15 14 13 | --s-d-r
|
spherical objects with useful functions, operators and index support |
country
|
18 17 16 15 14 13 | --s-d-r
|
Country data type, ISO 3166-1 |
pg_xenophile
|
18 17 16 15 14 13 | ----d--
|
More than the bare necessities for PostgreSQL i18n and l10n. |
l10n_table_dependent_extension
|
18 17 16 15 14 13 | ----dtr
|
PostgreSQL l10n toolbox |
currency
|
18 17 16 15 14 13 | --s-d-r
|
Custom PostgreSQL currency type in 1Byte |
collection
|
18 17 16 15 14 13 | --s-d-r
|
Memory optimized data type to be used inside of plpglsql func |
pgmp
|
18 17 16 15 14 13 | --s-d-r
|
Multiple Precision Arithmetic extension |
numeral
|
18 17 16 15 14 13 | --s-d-r
|
numeral datatypes extension |
pg_rational
|
18 17 16 15 14 13 | --s-d--
|
bigint fractions |
uint
|
18 17 16 15 14 13 | --s-d-r
|
unsigned integer types |
uint128
|
18 17 16 15 14 13 | --s-d-r
|
Native uint128 type |
hashtypes
|
18 17 16 15 14 13 | --s-d--
|
sha1, md5 and other data types for PostgreSQL |
ip4r
|
18 17 16 15 14 13 | --s-d-r
|
IPv4/v6 and IPv4/v6 range index type for PostgreSQL |
pg_duration
|
18 17 16 15 14 13 | --s-d-r
|
data type for representing durations |
uri
|
18 17 16 15 14 13 | --s-d-r
|
URI Data type for PostgreSQL |
emailaddr
|
18 17 16 15 14 13 | --s-d--
|
Email address type for PostgreSQL |
acl
|
18 17 16 15 14 13 | --s-d-r
|
ACL Data type |
debversion
|
18 17 16 15 14 13 | --s-d-r
|
Debian version number data type |
pg_rrule
|
18 17 16 15 14 13 | --s-d-r
|
RRULE field type for PostgreSQL |
timestamp9
|
18 17 16 15 14 13 | --s-d--
|
timestamp nanosecond resolution |
chkpass
|
18 17 16 15 14 13 | --s-d--
|
data type for auto-encrypted passwords |
isn
|
18 17 16 15 14 13 | c-s-dt-
|
data types for international product numbering standards |
seg
|
18 17 16 15 14 13 | c-s-dt-
|
data type for representing line segments or floating-point intervals |
cube
|
18 17 16 15 14 13 | c-s-d--
|
data type for multidimensional cubes |
ltree
|
18 17 16 15 14 13 | c-s-dt-
|
data type for hierarchical tree-like structures |
hstore
|
18 17 16 15 14 13 | c-s-dt-
|
data type for storing sets of (key, value) pairs |
citext
|
18 17 16 15 14 13 | c-s-dt-
|
data type for case-insensitive character strings |
xml2
|
18 17 16 15 14 13 | c---d--
|
XPath querying and XSLT |
gzip
|
18 17 16 15 14 13 | --s-d-r
|
gzip and gunzip functions. |
bzip
|
18 17 16 15 14 13 | --s-d--
|
Bzip compression and decompression |
zstd
|
18 17 16 15 14 13 | --s-d-r
|
Zstandard compression algorithm implementation in PostgreSQL |
http
|
18 17 16 15 14 13 | --s-d--
|
HTTP client for PostgreSQL, allows web page retrieval inside the database. |
pg_net
|
18 17 16 15 14 13 | --sLd--
|
Async HTTP Requests |
pg_curl
|
18 17 16 15 14 13 | --s-d-r
|
Run curl actions for data transfer in URL syntax |
pgjq
|
18 17 16 15 14 13 | --s-dtr
|
Use jq in Postgres |
pgjwt
|
18 17 16 15 14 13 | --s-dt-
|
JSON Web Token API for Postgresql |
pg_smtp_client
|
18 17 16 15 14 13 | --s-dt-
|
PostgreSQL extension to send email using SMTP |
pg_html5_email_address
|
18 17 16 15 14 13 | ----d-r
|
PostgreSQL email validation that is consistent with the HTML5 spec |
url_encode
|
18 17 16 15 14 13 | --s-d-r
|
url_encode, url_decode functions |
pgsql_tweaks
|
18 17 16 15 14 13 | --s-d-r
|
Some functions and views for daily usage |
pg_extra_time
|
18 17 16 15 14 13 | --s-dtr
|
Some date time functions and operators that, |
pgpcre
|
18 17 16 15 14 13 | --s-d-r
|
Perl Compatible Regular Expression functions |
icu_ext
|
18 17 16 15 14 13 | --s-d-r
|
Access ICU functions |
pgqr
|
18 17 16 15 14 13 | --s-d-r
|
QR Code generator from PostgreSQL |
pg_protobuf
|
18 17 16 15 14 13 | --s-d-r
|
Protobuf support for PostgreSQL |
envvar
|
18 17 16 15 14 13 | --s-d--
|
Fetch the value of an environment variable |
floatfile
|
18 17 16 15 14 13 | --s-d-r
|
Simple file storage for arrays of floats |
pg_render
|
18 17 16 15 14 13 | --s-d--
|
Render HTML in SQL |
pg_readme
|
18 17 16 15 14 13 | ----dtr
|
Generate a README.md document for a database extension or schema |
pg_readme_test_extension
|
18 17 16 15 14 13 | ----dtr
|
Test generating a README.md document for extension or schema |
ddl_historization
|
18 17 16 15 14 13 | ----d--
|
Historize the ddl changes inside PostgreSQL database |
data_historization
|
18 17 16 15 14 13 | ----dt-
|
PLPGSQL Script to historize data in partitionned table |
schedoc
|
18 17 16 15 14 13 | ----d--
|
Cross documentation between Django and DBT projects |
hashlib
|
18 17 16 15 14 13 | --s-dtr
|
Stable hash functions for Postgres |
xxhash
|
18 17 16 15 14 13 | --s-dtr
|
xxhash functions for PostgreSQL |
shacrypt
|
18 17 16 15 14 13 | --s-d-r
|
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes |
cryptint
|
18 17 16 15 14 13 | --s-d-r
|
Encryption functions for int and bigint values |
pguecc
|
18 17 16 15 14 13 | --s-d-r
|
uECC bindings for Postgres |
sparql
|
18 17 16 15 14 13 | ----d--
|
Query SPARQL datasource with SQL |
pg_idkit
|
18 17 16 15 14 13 | --s-d--
|
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
pgx_ulid
|
18 17 16 15 14 13 | --sLd--
|
ulid type and methods |
pg_uuidv7
|
18 17 16 15 14 13 | --s-d-r
|
Create UUIDv7 values in postgres |
permuteseq
|
18 17 16 15 14 13 | --s-d-r
|
Pseudo-randomly permute sequences with a format-preserving encryption on elements |
pg_hashids
|
18 17 16 15 14 13 | --s-d-r
|
Short unique id generator for PostgreSQL, using hashids |
sequential_uuids
|
18 17 16 15 14 13 | --s-d-r
|
generator of sequential UUIDs |
topn
|
18 17 16 15 14 13 | --s-d--
|
type for top-n JSONB |
quantile
|
18 17 16 15 14 13 | --s-d--
|
Quantile aggregation function |
lower_quantile
|
18 17 16 15 14 13 | --s-d--
|
Lower quantile aggregate function |
count_distinct
|
18 17 16 15 14 13 | --s-d-r
|
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
ddsketch
|
18 17 16 15 14 13 | --s-d-r
|
Provides ddsketch aggregate function |
vasco
|
18 17 16 15 14 13 | --s-d-r
|
discover hidden correlations in your data with MIC |
xicor
|
18 17 16 15 14 13 | --s-dtr
|
XI Correlation Coefficient in Postgres |
tdigest
|
18 17 16 15 14 13 | --s-d-r
|
Provides tdigest aggregate function. |
first_last_agg
|
18 17 16 15 14 13 | --s-d-r
|
first() and last() aggregate functions |
extra_window_functions
|
18 17 16 15 14 13 | --s-d-r
|
Extra Window Functions for PostgreSQL |
floatvec
|
18 17 16 15 14 13 | --s-d-r
|
Math for vectors (arrays) of numbers |
aggs_for_vecs
|
18 17 16 15 14 13 | --s-d-r
|
Aggregate functions for array inputs |
aggs_for_arrays
|
18 17 16 15 14 13 | --s-d-r
|
Various functions for computing statistics on arrays of numbers |
pg_csv
|
18 17 16 15 14 13 | --s-dtr
|
Flexible CSV processing for Postgres |
arraymath
|
18 17 16 15 14 13 | --s-d-r
|
Array math and operators that work element by element on the contents of arrays |
pg_math
|
18 17 16 15 14 13 | --s-d-r
|
GSL statistical functions for postgresql |
random
|
18 17 16 15 14 13 | --s-d-r
|
random data generator |
base36
|
18 17 16 15 14 13 | --s-d--
|
Integer Base36 types |
base62
|
18 17 16 15 14 13 | --s-d--
|
Base62 extension for PostgreSQL |
pg_base58
|
18 17 16 15 14 13 | --s-d--
|
Base58 Encoder/Decoder Extension for PostgreSQL |
financial
|
18 17 16 15 14 13 | --s-d-r
|
Financial aggregate functions |
convert
|
18 17 16 15 14 13 | --s-dt-
|
conversion functions for spatial, routing and other specialized uses |
refint
|
18 17 16 15 14 13 | c-s-d--
|
functions for implementing referential integrity (obsolete) |
autoinc
|
18 17 16 15 14 13 | c-s-d--
|
functions for autoincrementing fields |
insert_username
|
18 17 16 15 14 13 | c-s-d--
|
functions for tracking who changed a table |
moddatetime
|
18 17 16 15 14 13 | c-s-d--
|
functions for tracking last modification time |
tsm_system_time
|
18 17 16 15 14 13 | c-s-dt-
|
TABLESAMPLE method which accepts time in milliseconds as a limit |
dict_xsyn
|
18 17 16 15 14 13 | c-s-d--
|
text search dictionary template for extended synonym processing |
tsm_system_rows
|
18 17 16 15 14 13 | c-s-dt-
|
TABLESAMPLE method which accepts number of rows as a limit |
tcn
|
18 17 16 15 14 13 | c-s-dt-
|
Triggered change notifications |
uuid-ossp
|
18 17 16 15 14 13 | c-s-dt-
|
generate universally unique identifiers (UUIDs) |
btree_gist
|
18 17 16 15 14 13 | c-s-dt-
|
support for indexing common datatypes in GiST |
btree_gin
|
18 17 16 15 14 13 | c-s-dt-
|
support for indexing common datatypes in GIN |
intarray
|
18 17 16 15 14 13 | c---dt-
|
functions, operators, and index support for 1-D arrays of integers |
intagg
|
18 17 16 15 14 13 | c---d--
|
integer aggregator and enumerator (obsolete) |
dict_int
|
18 17 16 15 14 13 | c-s-dt-
|
text search dictionary template for integers |
unaccent
|
18 17 16 15 14 13 | c-s-dt-
|
text search dictionary that removes accents |
pg_repack
|
18 17 16 15 14 13 | -bs-d--
|
Reorganize tables in PostgreSQL databases with minimal locks |
pg_rewrite
|
18 17 16 15 14 13 | --sLd-r
|
Tool allows read write to the table during the rewriting |
pg_squeeze
|
18 17 16 15 14 13 | --sLd--
|
A tool to remove unused space from a relation. |
pg_dirtyread
|
18 17 16 15 14 13 | --s-d-r
|
Read dead but unvacuumed rows from table |
pgfincore
|
18 17 16 15 14 13 | --s-d-r
|
examine and manage the os buffer cache |
pg_cooldown
|
18 17 16 15 14 13 | --s-d-r
|
remove buffered pages for specific relations |
ddlx
|
18 17 16 15 14 13 | --s-d--
|
DDL eXtractor functions |
prioritize
|
18 17 16 15 14 13 | --s-d-r
|
get and set the priority of PostgreSQL backends |
pg_checksums
|
18 17 16 15 14 13 | --s---r
|
Activate/deactivate/verify checksums in offline Postgres clusters |
pg_readonly
|
18 17 16 15 14 13 | --s-d--
|
cluster database read only |
pgdd
|
18 17 16 15 14 13 | --s-dt-
|
Introspect pg data dictionary via standard SQL |
pg_permissions
|
18 17 16 15 14 13 | --s-dt-
|
view object permissions and compare them with the desired state |
pgautofailover
|
18 17 16 15 14 13 | --sLd--
|
pg_auto_failover |
pg_catcheck
|
18 17 16 15 14 13 | --s-d--
|
Diagnosing system catalog corruption |
pre_prepare
|
18 17 16 15 14 13 | --s-d-r
|
Pre Prepare your Statement server side |
pg_upless
|
18 17 16 15 14 13 | ----dt-
|
Detect Useless UPDATE |
pgcozy
|
18 17 16 15 14 13 | ----d--
|
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. |
pg_orphaned
|
18 17 16 15 14 13 | --s-d--
|
Deal with orphaned files |
pg_crash
|
18 17 16 15 14 13 | --sL---
|
Send random signals to random processes |
pg_cheat_funcs
|
18 17 16 15 14 13 | --s-d-r
|
Provides cheat (but useful) functions |
fio
|
18 17 16 15 14 13 | --s-d-r
|
PostgreSQL File I/O Functions |
pg_savior
|
18 17 16 15 14 13 | --s-d-r
|
Postgres extension to save OOPS mistakes |
safeupdate
|
18 17 16 15 14 13 | --sL---
|
Require criteria for UPDATE and DELETE |
pg_drop_events
|
18 17 16 15 14 13 | ----d--
|
logs transaction ids of drop table, drop column, drop materialized view statements |
table_log
|
18 17 16 15 14 13 | --s-d--
|
record table modification logs and PITR for table/row |
pgagent
|
18 17 16 15 14 13 | --s-d--
|
A PostgreSQL job scheduler |
pg_prewarm
|
18 17 16 15 14 13 | c-sLd--
|
prewarm relation data |
pgpool_adm
|
18 17 16 15 14 13 | ----d--
|
Administrative functions for pgPool |
pgpool_recovery
|
18 17 16 15 14 13 | ----d--
|
recovery functions for pgpool-II for V4.3 |
pgpool_regclass
|
18 17 16 15 14 13 | ----d--
|
replacement for regclass |
lo
|
18 17 16 15 14 13 | c-s-dt-
|
Large Object maintenance |
basic_archive
|
18 17 16 15 14 13 | c-s----
|
an example of an archive module |
basebackup_to_shell
|
18 17 16 15 14 13 | c-s----
|
adds a custom basebackup target called shell |
old_snapshot
|
18 17 16 15 14 13 | c-s-d--
|
utilities in support of old_snapshot_threshold |
adminpack
|
18 17 16 15 14 13 | c-s-d--
|
administrative functions for PostgreSQL |
amcheck
|
18 17 16 15 14 13 | c-s-d--
|
functions for verifying relation integrity |
pg_surgery
|
18 17 16 15 14 13 | c-s-d--
|
extension to perform surgery on a damaged relation |
pg_profile
|
18 17 16 15 14 13 | --s-d--
|
PostgreSQL load profile repository and report builder |
pg_tracing
|
18 17 16 15 14 13 | --sLd-r
|
Distributed Tracing for PostgreSQL |
pg_show_plans
|
18 17 16 15 14 13 | --s-d-r
|
show query plans of all currently running SQL statements |
pg_stat_kcache
|
18 17 16 15 14 13 | --sLd-r
|
Kernel statistics gathering |
pg_stat_monitor
|
18 17 16 15 14 13 | --sLd-r
|
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
|
18 17 16 15 14 13 | --sLd--
|
An extension collecting statistics about quals |
pg_store_plans
|
18 17 16 15 14 13 | --sLd-r
|
track plan statistics of all SQL statements executed |
pg_track_settings
|
18 17 16 15 14 13 | --s-dt-
|
Track settings changes |
pg_wait_sampling
|
18 17 16 15 14 13 | --sLd-r
|
sampling based statistics of wait events |
pgsentinel
|
18 17 16 15 14 13 | --sLd-r
|
active session history |
system_stats
|
18 17 16 15 14 13 | --s-d-r
|
EnterpriseDB system statistics for PostgreSQL |
meta
|
18 17 16 15 14 13 | ----d-r
|
Normalized, friendlier system catalog for PostgreSQL |
pgnodemx
|
18 17 16 15 14 13 | --s-d-r
|
Capture node OS metrics via SQL queries |
pg_proctab
|
18 17 16 15 14 13 | --s-d-r
|
PostgreSQL extension to access the OS process table |
pg_sqlog
|
18 17 16 15 14 13 | --s-d--
|
Provide SQL interface to logs |
bgw_replstatus
|
18 17 16 15 14 13 | --sL---
|
Small PostgreSQL background worker to report whether a node is a replication master or standby |
pgmeminfo
|
18 17 16 15 14 13 | --s-d--
|
show memory usage |
toastinfo
|
18 17 16 15 14 13 | --s-d-r
|
show details on toasted datums |
explain_ui
|
18 17 16 15 14 13 | --s-dt-
|
easily jump into a visual plan UI for any SQL query |
pg_relusage
|
18 17 16 15 14 13 | --sL---
|
Log all the queries that reference a particular column |
pagevis
|
18 17 16 15 14 13 | ----d-r
|
Visualise database pages in ascii code |
powa
|
18 17 16 15 14 13 | --s-d--
|
PostgreSQL Workload Analyser-core |
pg_overexplain
|
18 17 16 15 14 13 | c-sL---
|
Allow EXPLAIN to dump even more details |
pg_logicalinspect
|
18 17 16 15 14 13 | c-s-d--
|
Logical decoding components inspection |
pageinspect
|
18 17 16 15 14 13 | c-s-d--
|
inspect the contents of database pages at a low level |
pgrowlocks
|
18 17 16 15 14 13 | c-s-d--
|
show row-level locking information |
sslinfo
|
18 17 16 15 14 13 | c-s-d--
|
information about SSL certificates |
pg_buffercache
|
18 17 16 15 14 13 | c-s-d--
|
examine the shared buffer cache |
pg_walinspect
|
18 17 16 15 14 13 | c-s-d--
|
functions to inspect contents of PostgreSQL Write-Ahead Log |
pg_freespacemap
|
18 17 16 15 14 13 | c-s-d--
|
examine the free space map (FSM) |
pg_visibility
|
18 17 16 15 14 13 | c-s-d--
|
examine the visibility map (VM) and page-level visibility info |
pgstattuple
|
18 17 16 15 14 13 | c-s-d--
|
show tuple-level statistics |
auto_explain
|
18 17 16 15 14 13 | c-sL---
|
Provides a means for logging execution plans of slow statements automatically |
pg_stat_statements
|
18 17 16 15 14 13 | c-sLd--
|
track planning and execution statistics of all SQL statements executed |
passwordcheck_cracklib
|
18 17 16 15 14 13 | --sL---
|
Strengthen PostgreSQL user password checks with cracklib |
supautils
|
18 17 16 15 14 13 | --sL---
|
Extension that secures a cluster on a cloud environment |
pgsodium
|
18 17 16 15 14 13 | --sLd--
|
Postgres extension for libsodium functions |
supabase_vault
|
18 17 16 15 14 13 | --s-d--
|
Supabase Vault Extension |
pg_session_jwt
|
18 17 16 15 14 13 | --s-dt-
|
Manage authentication sessions using JWTs |
anon
|
18 17 16 15 14 13 | --sLd--
|
PostgreSQL Anonymizer (anon) extension |
pg_tde
|
18 17 16 15 14 13 | --sLd-r
|
Percona pg_tde access method |
pgsmcrypto
|
18 17 16 15 14 13 | --s-d--
|
PostgreSQL SM Algorithm Extension |
pgaudit
|
18 17 16 15 14 13 | --sLd-r
|
provides auditing functionality |
pgauditlogtofile
|
18 17 16 15 14 13 | --s-d-r
|
pgAudit addon to redirect audit log to an independent file |
pg_auth_mon
|
18 17 16 15 14 13 | --s-d-r
|
monitor connection attempts per user |
credcheck
|
18 17 16 15 14 13 | --sLd--
|
credcheck - postgresql plain text credential checker |
pgcryptokey
|
18 17 16 15 14 13 | --s-d-r
|
cryptographic key management |
pg_jobmon
|
18 17 16 15 14 13 | --s-d--
|
Extension for logging and monitoring functions in PostgreSQL |
logerrors
|
18 17 16 15 14 13 | --s-d-r
|
Function for collecting statistics about messages in logfile |
login_hook
|
18 17 16 15 14 13 | --s-d--
|
login_hook - hook to execute login_hook.login() at login time |
set_user
|
18 17 16 15 14 13 | --s-d--
|
similar to SET ROLE but with added logging |
pg_snakeoil
|
18 17 16 15 14 13 | --sL--r
|
The PostgreSQL Antivirus |
pgextwlist
|
18 17 16 15 14 13 | --sL---
|
PostgreSQL Extension Whitelisting |
pg_auditor
|
18 17 16 15 14 13 | ----d-r
|
Audit data changes and provide flashback ability |
sslutils
|
18 17 16 15 14 13 | --s-d--
|
A Postgres extension for managing SSL certificates through SQL |
noset
|
18 17 16 15 14 13 | --sLd-r
|
Module for blocking SET variables for non-super users. |
sepgsql
|
18 17 16 15 14 13 | c-sL---
|
label-based mandatory access control (MAC) based on SELinux security policy. |
auth_delay
|
18 17 16 15 14 13 | c-sL---
|
pause briefly before reporting authentication failure |
pgcrypto
|
18 17 16 15 14 13 | c-s-dt-
|
cryptographic functions |
passwordcheck
|
18 17 16 15 14 13 | c-sL---
|
checks user passwords and reject weak password |
wrappers
|
18 17 16 15 14 13 | --s-dt-
|
Foreign data wrappers developed by Supabase |
multicorn
|
18 17 16 15 14 13 | --s-d--
|
Fetch foreign data in Python in your PostgreSQL server. |
odbc_fdw
|
18 17 16 15 14 13 | --s-d-r
|
Foreign data wrapper for accessing remote databases using ODBC |
jdbc_fdw
|
18 17 16 15 14 13 | --s-d-r
|
foreign-data wrapper for remote servers available over JDBC |
pgspider_ext
|
18 17 16 15 14 13 | --s-d-r
|
foreign-data wrapper for remote PGSpider servers |
mysql_fdw
|
18 17 16 15 14 13 | --s-d-r
|
Foreign data wrapper for querying a MySQL server |
oracle_fdw
|
18 17 16 15 14 13 | --s-d--
|
foreign data wrapper for Oracle access |
tds_fdw
|
18 17 16 15 14 13 | --s-d-r
|
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
db2_fdw
|
18 17 16 15 14 13 | --s-d--
|
foreign data wrapper for DB2 access |
sqlite_fdw
|
18 17 16 15 14 13 | --s-d-r
|
SQLite Foreign Data Wrapper |
pgbouncer_fdw
|
18 17 16 15 14 13 | --s-d--
|
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions |
mongo_fdw
|
18 17 16 15 14 13 | --s-d--
|
foreign data wrapper for MongoDB access |
redis_fdw
|
18 17 16 15 14 13 | --s-d-r
|
Foreign data wrapper for querying a Redis server |
redis
|
18 17 16 15 14 13 | --s-d-r
|
Send redis pub/sub messages to Redis from PostgreSQL Directly |
kafka_fdw
|
18 17 16 15 14 13 | --s-d-r
|
kafka Foreign Data Wrapper for CSV formatted messages |
hdfs_fdw
|
18 17 16 15 14 13 | --s-d--
|
foreign-data wrapper for remote hdfs servers |
firebird_fdw
|
18 17 16 15 14 13 | --s-d-r
|
Foreign data wrapper for Firebird |
aws_s3
|
18 17 16 15 14 13 | ----d-r
|
aws_s3 postgres extension to import/export data from/to s3 |
log_fdw
|
18 17 16 15 14 13 | --s-d--
|
foreign-data wrapper for Postgres log file access |
dblink
|
18 17 16 15 14 13 | c-s-d--
|
connect to other PostgreSQL databases from within a database |
file_fdw
|
18 17 16 15 14 13 | c-s-d--
|
foreign-data wrapper for flat file access |
postgres_fdw
|
18 17 16 15 14 13 | c-s-d--
|
foreign-data wrapper for remote PostgreSQL servers |
documentdb
|
18 17 16 15 14 13 | --sLd--
|
API surface for DocumentDB for PostgreSQL |
documentdb_core
|
18 17 16 15 14 13 | --sLd--
|
Core API surface for DocumentDB for PostgreSQL |
documentdb_distributed
|
18 17 16 15 14 13 | --sLd--
|
Multi-Node API surface for DocumentDB |
orafce
|
18 17 16 15 14 13 | --s-d--
|
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
pgtt
|
18 17 16 15 14 13 | --s-d--
|
Extension to add Global Temporary Tables feature to PostgreSQL |
session_variable
|
18 17 16 15 14 13 | --s-d-r
|
Registration and manipulation of session variables and constants |
pg_statement_rollback
|
18 17 16 15 14 13 | --sL---
|
Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
pg_dbms_metadata
|
18 17 16 15 14 13 | --s-d--
|
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
pg_dbms_lock
|
18 17 16 15 14 13 | --s-d--
|
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
pg_dbms_job
|
18 17 16 15 14 13 | --s-d--
|
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
pg_dbms_errlog
|
18 17 16 15 14 13 | --s-d--
|
Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. |
babelfishpg_common
|
18 17 16 15 14 13 | --s-d-r
|
SQL Server Transact SQL Datatype Support |
babelfishpg_tsql
|
18 17 16 15 14 13 | --s-d-r
|
SQL Server Transact SQL compatibility |
babelfishpg_tds
|
18 17 16 15 14 13 | --sLd-r
|
SQL Server TDS protocol extension |
babelfishpg_money
|
18 17 16 15 14 13 | --s-dt-
|
SQL Server Money Data Type |
spat
|
18 17 16 15 14 13 | --s-d-r
|
Redis-like In-Memory DB Embedded in Postgres |
pgmemcache
|
18 17 16 15 14 13 | --s-d-r
|
memcached interface |
pglogical
|
18 17 16 15 14 13 | --sLd--
|
PostgreSQL Logical Replication |
pglogical_origin
|
18 17 16 15 14 13 | --s-d--
|
Dummy extension for compatibility when upgrading from Postgres 9.4 |
pglogical_ticker
|
18 17 16 15 14 13 | --sLd--
|
Have an accurate view on pglogical replication delay |
pgl_ddl_deploy
|
18 17 16 15 14 13 | --s-d--
|
automated ddl deployment using pglogical |
pg_failover_slots
|
18 17 16 15 14 13 | --sL--r
|
PG Failover Slots extension |
db_migrator
|
18 17 16 15 14 13 | ----dt-
|
Tools to migrate other databases to PostgreSQL |
pgactive
|
18 17 16 15 14 13 | -bsLd--
|
Active-Active Replication Extension for PostgreSQL |
wal2json
|
18 17 16 15 14 13 | --s----
|
Changing data capture in JSON format |
wal2mongo
|
18 17 16 15 14 13 | --s----
|
PostgreSQL logical decoding output plugin for MongoDB |
decoderbufs
|
18 17 16 15 14 13 | --s----
|
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
decoder_raw
|
18 17 16 15 14 13 | --s----
|
Output plugin for logical replication in Raw SQL format |
mimeo
|
18 17 16 15 14 13 | ----d--
|
Extension for specialized, per-table replication between PostgreSQL instances |
repmgr
|
18 17 16 15 14 13 | --s-d--
|
Replication manager for PostgreSQL |
pg_fact_loader
|
18 17 16 15 14 13 | --s-d--
|
build fact tables with Postgres |
pg_bulkload
|
18 17 16 15 14 13 | -bs-d--
|
pg_bulkload is a high speed data loading utility for PostgreSQL |
test_decoding
|
18 17 16 15 14 13 | c-s----
|
SQL-based test/example module for WAL logical decoding |
pgoutput
|
18 17 16 15 14 13 | c-s----
|
Logical Replication output plugin |
Last updated on