Extensions
Extensions
Statistics
| Category | All | PGDG | PIGSTY | CONTRIB | MISS | PG18 | PG17 | PG16 | PG15 | PG14 | PG13 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ALL | 437 | 149 | 265 | 71 | 0 | 405 | 426 | 426 | 428 | 413 | 386 |
| EL | 431 | 143 | 265 | 71 | 6 | 393 | 418 | 420 | 422 | 410 | 382 |
| Debian | 423 | 105 | 247 | 71 | 14 | 391 | 413 | 412 | 414 | 402 | 371 |
Categories
Extensions
There are 437 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 |
pg_biscuit | 18 17 16 15 14 13 | --s-d-- | IAM-LIKE pattern matching with bitmap indexing |
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 |
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 |
pg_retry | 18 17 16 15 14 13 | --s-d-r | Retry SQL statements on transient errors with exponential backoff |
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 |
typeid | 18 17 16 15 14 13 | --s-d-- | Allows to use TypeIDs in Postgres natively |
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 |
omnisketch | 18 17 16 15 14 13 | --s-d-r | data structure for on-line agg of data into approximate sketch |
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 |
pg_weighted_statistics | 18 17 16 15 14 13 | --s-dtr | High-performance weighted statistics functions for sparse data |
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 |
pglinter | 18 17 16 15 14 13 | --s-d-- | PostgreSQL Linting and Analysis Extension |
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 |
pgsmcrypto | 18 17 16 15 14 13 | --s-d-- | PostgreSQL SM Algorithm Extension |
pg_enigma | 18 17 16 15 14 13 | --s-d-- | Encrypted postgres data type |
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_auditor | 18 17 16 15 14 13 | ----d-r | Audit data changes and provide flashback ability |
logerrors | 18 17 16 15 14 13 | --s-d-r | Function for collecting statistics about messages in logfile |
pg_auth_mon | 18 17 16 15 14 13 | --s-d-r | monitor connection attempts per user |
pg_jobmon | 18 17 16 15 14 13 | --s-d-- | Extension for logging and monitoring functions in PostgreSQL |
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 |
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 |
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. |
pg_tde | 18 17 16 15 14 13 | --sLd-r | Percona pg_tde access method |
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