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

Category Count Extensions
TIME
11
timescaledb
timescaledb_toolkit
timeseries
periods
temporal_tables
emaj
table_version
pg_cron
pg_task
pg_later
pg_background
GIS
20
postgis
postgis_topology
postgis_raster
postgis_sfcgal
postgis_tiger_geocoder
address_standardizer
address_standardizer_data_us
pgrouting
pointcloud
pointcloud_postgis
h3
h3_postgis
q3c
ogr_fdw
geoip
pg_polyline
pg_geohash
mobilitydb
tzf
earthdistance
RAG
10
vector
vchord
vectorscale
vectorize
pg_similarity
smlar
pg_summarize
pg_tiktoken
pg4ml
pgml
FTS
20
pg_search
pgroonga
pgroonga_database
pg_bigm
zhparser
pg_bestmatch
vchord_bm25
pg_tokenizer
hunspell_cs_cz
hunspell_de_de
hunspell_en_us
hunspell_fr
hunspell_ne_np
hunspell_nl_nl
hunspell_nn_no
hunspell_pt_pt
hunspell_ru_ru
hunspell_ru_ru_aot
fuzzystrmatch
pg_trgm
OLAP
13
citus
citus_columnar
columnar
pg_analytics
pg_duckdb
pg_mooncake
duckdb_fdw
pg_parquet
pg_fkpart
pg_partman
plproxy
pg_strom
tablefunc
FEAT
59
age
hll
rum
pg_graphql
pg_jsonschema
jsquery
pg_hint_plan
hypopg
index_advisor
plan_filter
imgsmlr
pg_ivm
pg_incremental
pgmq
pgq
orioledb
pg_cardano
rdkit
omni
omni_auth
omni_aws
omni_cloudevents
omni_containers
omni_credentials
omni_csv
omni_datasets
omni_email
omni_http
omni_httpc
omni_httpd
omni_id
omni_json
omni_kube
omni_ledger
omni_manifest
omni_mimetypes
omni_os
omni_polyfill
omni_python
omni_regex
omni_rest
omni_schema
omni_seq
omni_service
omni_session
omni_shmem
omni_sql
omni_sqlite
omni_test
omni_txn
omni_types
omni_var
omni_vfs
omni_vfs_types_v1
omni_web
omni_worker
omni_xml
omni_yaml
bloom
LANG
33
pg_tle
plv8
pljs
pllua
hstore_pllua
plluau
hstore_plluau
plprql
pldbgapi
plpgsql_check
plprofiler
plsh
pljava
plr
plxslt
pgtap
faker
dbt2
pltcl
pltclu
plperl
bool_plperl
hstore_plperl
jsonb_plperl
plperlu
bool_plperlu
jsonb_plperlu
hstore_plperlu
plpgsql
plpython3u
jsonb_plpython3u
ltree_plpython3u
hstore_plpython3u
TYPE
37
prefix
semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap
pgfaceting
pg_sphere
country
pg_xenophile
l10n_table_dependent_extension
currency
collection
pgmp
numeral
pg_rational
uint
uint128
hashtypes
ip4r
pg_duration
uri
emailaddr
acl
debversion
pg_rrule
timestamp9
chkpass
isn
seg
cube
ltree
hstore
citext
xml2
UTIL
31
gzip
bzip
zstd
http
pg_net
pg_curl
pgjq
pgjwt
pg_smtp_client
pg_html5_email_address
url_encode
pgsql_tweaks
pg_extra_time
pgpcre
icu_ext
pgqr
pg_protobuf
envvar
floatfile
pg_render
pg_readme
pg_readme_test_extension
ddl_historization
data_historization
schedoc
hashlib
xxhash
shacrypt
cryptint
pguecc
sparql
FUNC
44
omnisketch
pg_idkit
pgx_ulid
pg_uuidv7
permuteseq
pg_hashids
sequential_uuids
topn
quantile
lower_quantile
count_distinct
ddsketch
vasco
xicor
tdigest
first_last_agg
extra_window_functions
floatvec
aggs_for_vecs
aggs_for_arrays
pg_csv
arraymath
pg_math
random
base36
base62
pg_base58
financial
convert
refint
autoinc
insert_username
moddatetime
tsm_system_time
dict_xsyn
tsm_system_rows
tcn
uuid-ossp
btree_gist
btree_gin
intarray
intagg
dict_int
unaccent
ADMIN
37
pg_repack
pg_rewrite
pg_squeeze
pg_dirtyread
pgfincore
pg_cooldown
ddlx
prioritize
pg_checksums
pg_readonly
pgdd
pg_permissions
pgautofailover
pg_catcheck
pre_prepare
pg_upless
pgcozy
pg_orphaned
pg_crash
pg_cheat_funcs
fio
pg_savior
safeupdate
pg_drop_events
table_log
pgagent
pg_prewarm
pgpool_adm
pgpool_recovery
pgpool_regclass
lo
basic_archive
basebackup_to_shell
old_snapshot
adminpack
amcheck
pg_surgery
STAT
34
pg_profile
pg_tracing
pg_show_plans
pg_stat_kcache
pg_stat_monitor
pg_qualstats
pg_store_plans
pg_track_settings
pg_wait_sampling
pgsentinel
system_stats
meta
pgnodemx
pg_proctab
pg_sqlog
bgw_replstatus
pgmeminfo
toastinfo
explain_ui
pg_relusage
pagevis
powa
pg_overexplain
pg_logicalinspect
pageinspect
pgrowlocks
sslinfo
pg_buffercache
pg_walinspect
pg_freespacemap
pg_visibility
pgstattuple
auto_explain
pg_stat_statements
SEC
26
passwordcheck_cracklib
supautils
pgsodium
supabase_vault
pg_session_jwt
anon
pg_tde
pgsmcrypto
pgaudit
pgauditlogtofile
pg_auth_mon
credcheck
pgcryptokey
pg_jobmon
logerrors
login_hook
set_user
pg_snakeoil
pgextwlist
pg_auditor
sslutils
noset
sepgsql
auth_delay
pgcrypto
passwordcheck
FDW
22
wrappers
multicorn
odbc_fdw
jdbc_fdw
pgspider_ext
mysql_fdw
oracle_fdw
tds_fdw
db2_fdw
sqlite_fdw
pgbouncer_fdw
mongo_fdw
redis_fdw
redis
kafka_fdw
hdfs_fdw
firebird_fdw
aws_s3
log_fdw
dblink
file_fdw
postgres_fdw
SIM
17
documentdb
documentdb_core
documentdb_distributed
orafce
pgtt
session_variable
pg_statement_rollback
pg_dbms_metadata
pg_dbms_lock
pg_dbms_job
pg_dbms_errlog
babelfishpg_common
babelfishpg_tsql
babelfishpg_tds
babelfishpg_money
spat
pgmemcache
ETL
17
pglogical
pglogical_origin
pglogical_ticker
pgl_ddl_deploy
pg_failover_slots
db_migrator
pgactive
wal2json
wal2mongo
decoderbufs
decoder_raw
mimeo
repmgr
pg_fact_loader
pg_bulkload
test_decoding
pgoutput

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