Extensions

There are 431 available PostgreSQL extensions:

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

Attribute Legend: c:contrib b:bin s:lib l:load d:ddl t:trusted r:relocatable

Last updated on 2025-11-11