Extensions
There are 575 packaged PostgreSQL extensions:
| Extension | PG Versions | Attribute | Category | Description |
|---|---|---|---|---|
| timescaledb | 1817161514 | --sLdt- | TIME | Enables scalable inserts and complex queries for time-series data |
| timescaledb_toolkit | 1817161514 | --s-d-- | TIME | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities |
| pg_timeseries | 1817161514 | ----d-- | TIME | Convenience API for time series stack |
| periods | 1817161514 | --s-d-- | TIME | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| temporal_tables | 1817161514 | --s-d-r | TIME | temporal tables |
| emaj | 1817161514 | --s-d-- | TIME | Enables fine-grained write logging and time travel on subsets of the database. |
| table_version | 1817161514 | --s-d-- | TIME | PostgreSQL table versioning extension |
| pg_cron | 1817161514 | --sLd-- | TIME | Job scheduler for PostgreSQL |
| pg_task | 1817161514 | --sL--- | TIME | execute any sql command at any specific time at background |
| pg_later | 1817161514 | --sLd-- | TIME | Run queries now and get results later |
| pg_dispatch | 1817161514 | ----d-- | TIME | Asynchronous SQL dispatcher built on pg_cron |
| pg_background | 1817161514 | --s-d-r | TIME | Run SQL queries in the background |
| pg_when | 1817161514 | --s-d-- | TIME | Natural language time parsing for PostgreSQL |
| pg_stl | 1817161514 | --s-d-r | TIME | Time series analysis functions for PostgreSQL |
| cron_utils | 1817161514 | ----d-r | TIME | Parse cron expressions and compute previous or next trigger times |
| postgis | 1817161514 | --s-d-- | GIS | PostGIS geometry and geography spatial types and functions |
| postgis | 1817161514 | --s-d-- | GIS | PostGIS topology spatial types and functions |
| postgis | 1817161514 | --s-d-- | GIS | PostGIS raster types and functions |
| postgis | 1817161514 | --s-d-r | GIS | PostGIS SFCGAL functions |
| postgis | 1817161514 | --s-dt- | GIS | PostGIS tiger geocoder and reverse geocoder |
| postgis | 1817161514 | --s-d-r | GIS | Used to parse an address into constituent elements. Generally used to support geocoding address norm |
| postgis | 1817161514 | --s-d-r | GIS | Address Standardizer US dataset example |
| pgrouting | 1817161514 | --s-d-r | GIS | pgRouting Extension |
| pointcloud | 1817161514 | --s-d-- | GIS | data type for lidar point clouds |
| pointcloud | 1817161514 | --s-dt- | GIS | integration for pointcloud LIDAR data and PostGIS geometry data |
| pg_h3 | 1817161514 | --s-d-r | GIS | H3 bindings for PostgreSQL |
| pg_h3 | 1817161514 | --s-d-r | GIS | H3 PostGIS integration |
| q3c | 1817161514 | --s-d-r | GIS | q3c sky indexing plugin |
| ogr_fdw | 1817161514 | --s-d-r | GIS | foreign-data wrapper for GIS data access |
| geoip | 1817161514 | --s-d-- | GIS | IP-based geolocation query |
| pg_polyline | 1817161514 | --s-d-- | GIS | Fast Google Encoded Polyline encoding & decoding for postgres |
| pg_eviltransform | 1817161514 | --s-d-r | GIS | Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform |
| pg_geohash | 1817161514 | --s-d-r | GIS | Handle geohash based functionality for spatial coordinates |
| pghydro | 1817161514 | ----d-- | GIS | Drainage network analysis core for PostgreSQL and PostGIS |
| pghydro | 1817161514 | ----d-- | GIS | Raster hydrology extension for PgHydro |
| pghydro | 1817161514 | ----d-- | GIS | Hydrogeomorphological analysis extension for PgHydro |
| pghydro | 1817161514 | ----d-- | GIS | Output and reporting objects for PgHydro |
| pghydro | 1817161514 | ----d-- | GIS | Australian English output pack for PgHydro |
| pghydro | 1817161514 | ----d-- | GIS | Brazilian Portuguese output pack for PgHydro |
| pghydro | 1817161514 | ----d-- | GIS | Pfafstetter consistency checks for PgHydro |
| mobilitydb | 1817161514 | --sLd-- | GIS | MobilityDB geospatial trajectory data management & analysis platform |
| mobilitydb | 1817161514 | ----d-r | GIS | MobilityDB random data generator functions |
| pg_tzf | 1817161514 | --s-d-- | GIS | Fast lookup timezone name by GPS coordinates |
| earthdistance | 1817161514 | c-s-d-- | GIS | calculate great-circle distances on the surface of the Earth |
| qdgc | 1817161514 | ----dtr | GIS | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
| qdgc | 1817161514 | ----d-r | GIS | Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC. |
| pgvector | 1817161514 | --s-d-r | RAG | vector data type and ivfflat and hnsw access methods |
| vchord | 1817161514 | --sLd-r | RAG | Vector database plugin for Postgres, written in Rust |
| pgvectorscale | 1817161514 | --s-d-- | RAG | Advanced indexing for vector data with DiskANN |
| pg_vectorize | 1817161514 | --sLd-- | RAG | The simplest way to do vector search on Postgres |
| pg_similarity | 1817161514 | --s-d-r | RAG | support similarity queries |
| pg_rrf | 1817161514 | --s-d-- | RAG | Reciprocal rank fusion functions for hybrid search |
| smlar | 1817161514 | --s-d-r | RAG | Effective similarity search |
| pg_summarize | 1817161514 | --s-d-- | RAG | Text Summarization using LLMs. Built using pgrx |
| pg_tiktoken | 1817161514 | --s-d-- | RAG | tiktoken tokenizer for use with OpenAI models in postgres |
| pg_tiktoken_c | 1817161514 | --s-d-- | RAG | Fast tiktoken BPE tokenizer for PostgreSQL implemented in C |
| pg4ml | 1817161514 | ----dtr | RAG | Machine learning framework for PostgreSQL |
| pgml | 1817161514 | --sLdt- | RAG | Run AL/ML workloads with SQL interface |
| pgmnemo | 1817161514 | ----dt- | RAG | Single-plan multimodal agent memory for PostgreSQL |
| pgcontext | 1817161514 | --s-d-- | RAG | Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables. |
| pgcontext | 1817161514 | --s-d-- | RAG | Optional pgvector compatibility bridge for pgcontext HNSW indexes. |
| pg_turbovec | 1817161514 | --s-d-- | RAG | TurboQuant-compressed vector type and ANN index access method for PostgreSQL. |
| pg_search | 1817161514 | --sLd-- | FTS | Full text search for PostgreSQL using BM25 |
| pgroonga | 1817161514 | --s-dtr | FTS | Use Groonga as index, fast full text search platform for all languages! |
| pgroonga | 1817161514 | --s-dtr | FTS | PGroonga database management module |
| pg_bigm | 1817161514 | --sLd-r | FTS | create 2-gram (bigram) index for faster full text search. |
| zhparser | 1817161514 | --s-d-r | FTS | a parser for full-text search of Chinese |
| pg_bestmatch | 1817161514 | --sLd-- | FTS | Generate BM25 sparse vector inside PostgreSQL |
| vchord_bm25 | 1817161514 | --sLd-- | FTS | A postgresql extension for bm25 ranking algorithm |
| pg_tokenizer | 1817161514 | --sLd-- | FTS | Tokenizers for full-text search |
| pg_biscuit | 1817161514 | --s-d-- | FTS | IAM-LIKE pattern matching with bitmap indexing |
| pg_textsearch | 1817161514 | --sLd-- | FTS | Full-text search with BM25 ranking |
| pg_pinyin | 1817161514 | --s-d-r | FTS | Pinyin romanization and search helpers for PostgreSQL |
| pg_kazsearch | 1817161514 | --s-d-- | FTS | Kazakh full-text search extension for PostgreSQL |
| psql_bm25s | 1817161514 | --s-d-- | FTS | PostgreSQL extension for BM25-family lexical retrieval |
| pg_fts | 1817161514 | --s-dtr | FTS | Full-text search with BM25 and BM25F ranking |
| pg_cjk_parser | 1817161514 | --s-d-r | FTS | CJK bigram parser derived from PostgreSQL full-text search |
| pg_jieba | 1817161514 | --s-d-r | FTS | Chinese full-text search parser based on cppjieba |
| hunspell | 1817161514 | ----d-r | FTS | Czech Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | German Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | en_US Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | French Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | Nepali Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | Dutch Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | Norwegian (norsk) Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | Portuguese Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | Russian Hunspell Dictionary |
| hunspell | 1817161514 | ----d-r | FTS | Russian Hunspell Dictionary (from AOT.ru group) |
| fuzzystrmatch | 1817161514 | c-s-dt- | FTS | determine similarities and distance between strings |
| pg_trgm | 1817161514 | c-s-dt- | FTS | text similarity measurement and index searching based on trigrams |
| citus | 1817161514 | --sLd-- | OLAP | Distributed PostgreSQL as an extension |
| citus | 1817161514 | --s-d-- | OLAP | Citus columnar storage engine |
| hydra | 1817161514 | --s-d-- | OLAP | Hydra Columnar extension |
| pg_duckdb | 1817161514 | --sLd-- | OLAP | DuckDB Embedded in Postgres |
| pg_mooncake | 1817161514 | --sLd-- | OLAP | Columnstore Table in Postgres |
| storage_engine | 1817161514 | --sLd-- | OLAP | colcompress and rowcompress Table Access Methods with vectorized execution |
| pg_clickhouse | 1817161514 | --s-d-r | OLAP | Interfaces to query ClickHouse databases from PostgreSQL |
| duckdb_fdw | 1817161514 | --s-d-r | OLAP | DuckDB Foreign Data Wrapper |
| pg_parquet | 1817161514 | --sLd-- | OLAP | copy data between Postgres and Parquet |
| pg_ducklake | 1817161514 | --sLd-- | OLAP | DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet |
| pg_fkpart | 1817161514 | ----d-- | OLAP | Table partitioning by foreign key utility |
| pg_partman | 1817161514 | --s-d-- | OLAP | Extension to manage partitioned tables by time or ID |
| plproxy | 1817161514 | --s-d-- | OLAP | Database partitioning implemented as procedural language |
| pg_strom | 1817161514 | --s-d-- | OLAP | PG-Strom - big-data processing acceleration using GPU and NVME |
| pg_orca | 1817161514 | --sLd-- | OLAP | ORCA query optimizer as a PostgreSQL extension |
| pg_sorted_heap | 1817161514 | --sLd-- | OLAP | Sorted heap table AM with zone map scan pruning and built-in vector search |
| pg_lake | 1817161514 | -bsLd-- | OLAP | Data lake extension by Snowflake |
| pg_lake | 1817161514 | --sLd-- | OLAP | Extension development kit by Snowflake |
| pg_lake | 1817161514 | --sLd-- | OLAP | Automatic extension updater |
| pg_lake | 1817161514 | --s-d-- | OLAP | Map type for PostgreSQL, bundled as a required pg_lake component. |
| pg_lake | 1817161514 | --sLd-- | OLAP | Query engine for data lake queries |
| pg_lake | 1817161514 | --s-d-- | OLAP | Iceberg implementation in Postgres |
| pg_lake | 1817161514 | --sLd-- | OLAP | Data lake tables and Iceberg tables |
| pg_lake | 1817161514 | --sLd-- | OLAP | Copy to/from data lake files |
| tablefunc | 1817161514 | c-s-dt- | OLAP | functions that manipulate whole tables, including crosstab |
| age | 1817161514 | --sLd-- | FEAT | AGE graph database extension |
| pg_liquid | 1817161514 | --s-d-- | FEAT | Liquid-inspired Datalog graph query extension for PostgreSQL |
| one_sparse | 1817161514 | --s-d-- | FEAT | Sparse linear algebra and graph extension for PostgreSQL 18 |
| pggraph | 1817161514 | --s-d-- | FEAT | Graph database capabilities for PostgreSQL |
| pgrdf | 1817161514 | --sLd-- | FEAT | RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL |
| pgq | 1817161514 | --s-d-- | FEAT | Generic queue for PostgreSQL |
| pgmq | 1817161514 | ----d-- | FEAT | A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. |
| pgmb | 1817161514 | ----d-- | FEAT | A simple PostgreSQL Message Broker system |
| ulak | 1817161514 | --sLd-- | FEAT | Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery |
| fsm_core | 1817161514 | ----d-- | FEAT | Finite state machine toolkit for PostgreSQL |
| hll | 1817161514 | --s-d-- | FEAT | type for storing hyperloglog data |
| rum | 1817161514 | --s-d-r | FEAT | RUM index access method |
| pg_ai_query | 1817161514 | --s-d-r | FEAT | AI-powered SQL query generation for PostgreSQL |
| pg_ttl_index | 1817161514 | --sLd-r | FEAT | Automatic data expiration with TTL indexes |
| pg_graphql | 1817161514 | --s-d-- | FEAT | Add in-database GraphQL support |
| pg_jsonschema | 1817161514 | ----d-- | FEAT | PostgreSQL extension providing JSON Schema validation |
| jsonschema | 1817161514 | --s-d-r | FEAT | JSON Schema validation functions for PostgreSQL |
| jsquery | 1817161514 | --s-d-r | FEAT | data type for jsonb inspection |
| pg_hint_plan | 1817161514 | --sLd-- | FEAT | Give PostgreSQL ability to manually force some decisions in execution plans. |
| hypopg | 1817161514 | --s-d-r | FEAT | Hypothetical indexes for PostgreSQL |
| index_advisor | 1817161514 | ----d-r | FEAT | Query index advisor |
| pg_plan_filter | 1817161514 | --sL--- | FEAT | filter statements by their execution plans. |
| pg_variables | 1817161514 | --s-d-r | FEAT | Session-scoped variables with scalar, array, and record types |
| imgsmlr | 1817161514 | --s-d-r | FEAT | Image similarity with haar |
| pg_ivm | 1817161514 | --sLd-- | FEAT | incremental view maintenance on PostgreSQL |
| pg_incremental | 1817161514 | --s-d-- | FEAT | Incremental Processing by Crunchy Data |
| pg_trickle | 1817161514 | --sLd-- | FEAT | Streaming tables and differential view maintenance for PostgreSQL 18 |
| pg_durable | 1817161514 | --sLd-- | FEAT | Durable SQL functions for PostgreSQL |
| pg_disorder | 1817161514 | --sL--- | FEAT | Perturb unordered SELECT row order to expose order-dependent tests |
| pg_local_cache | 1817161514 | --sLd-- | FEAT | Transaction-aware shared-memory cache for ordinary PostgreSQL primary-key reads |
| provsql | 1817161514 | --sLdt- | FEAT | Semiring provenance and probability management for PostgreSQL |
| orioledb | 1817161514 | --sLd-r | FEAT | OrioleDB, the next generation transactional engine |
| pg_cardano | 1817161514 | --s-d-- | FEAT | A suite of Cardano-related tools |
| rdkit | 1817161514 | --s-d-r | FEAT | Cheminformatics functionality for PostgreSQL. |
| omnigres | 1817161514 | --sLd-- | FEAT | Advanced adapter for Postgres extensions |
| omnigres | 1817161514 | ----d-- | FEAT | Basic session management |
| omnigres | 1817161514 | ----dt- | FEAT | Amazon Web Services APIs (S3) |
| omnigres | 1817161514 | ----dt- | FEAT | CloudEvents support |
| omnigres | 1817161514 | --s-d-- | FEAT | Docker container management |
| omnigres | 1817161514 | ----d-- | FEAT | Application credential management |
| omni_csv | 1817161514 | --s-d-- | FEAT | CSV toolkit |
| omni_datasets | 1817161514 | ----d-- | FEAT | Dataset provisioning |
| omnigres | 1817161514 | ----d-- | FEAT | E-mail framework |
| omnigres | 1817161514 | ----d-- | FEAT | Basic HTTP types |
| omnigres | 1817161514 | --s-d-- | FEAT | HTTP client |
| omnigres | 1817161514 | --s-d-- | FEAT | HTTP server |
| omnigres | 1817161514 | --s-d-r | FEAT | Identity types |
| omnigres | 1817161514 | ----dt- | FEAT | JSON toolkit |
| omnigres | 1817161514 | --s-d-- | FEAT | Kubernetes (k8s) integration |
| omnigres | 1817161514 | --s-d-- | FEAT | Financial ledger |
| omnigres | 1817161514 | ----d-- | FEAT | Package installation manifests |
| omnigres | 1817161514 | ----d-- | FEAT | MIME types |
| omnigres | 1817161514 | --s-d-- | FEAT | Operating system integration |
| omnigres | 1817161514 | --s-d-- | FEAT | Postgres API polyfills |
| omnigres | 1817161514 | --s-d-- | FEAT | First-class Python support |
| omnigres | 1817161514 | --s-d-r | FEAT | PCRE-compatible regular expressions |
| omnigres | 1817161514 | ----d-- | FEAT | REST API toolkit (with PostgREST support) |
| omnigres | 1817161514 | ----d-- | FEAT | Advanced schema management tooling |
| omnigres | 1817161514 | --s-d-- | FEAT | Distributed integer sequences |
| omnigres | 1817161514 | ----d-- | FEAT | Service management |
| omnigres | 1817161514 | ----d-- | FEAT | Session management |
| omni_shmem | 1817161514 | --s-d-- | FEAT | Shared Memory Management |
| omnigres | 1817161514 | --s-d-- | FEAT | Programmatic SQL manipulation |
| omnigres | 1817161514 | --s-d-- | FEAT | Embedded SQLite |
| omnigres | 1817161514 | ----d-- | FEAT | Testing framework |
| omnigres | 1817161514 | --s-d-- | FEAT | Transaction management |
| omnigres | 1817161514 | --s-d-- | FEAT | Advanced types |
| omnigres | 1817161514 | --s-d-- | FEAT | Scoped variables |
| omnigres | 1817161514 | --s-d-- | FEAT | Virtual File System |
| omnigres | 1817161514 | ----d-- | FEAT | Virtual File System types (v1) |
| omnigres | 1817161514 | --s-d-- | FEAT | Common web stack primitives |
| omnigres | 1817161514 | --s-d-- | FEAT | Generalized worker pool |
| omnigres | 1817161514 | --s-d-- | FEAT | XML toolkit |
| omnigres | 1817161514 | --s-d-- | FEAT | YAML toolkit |
| pg_mentat | 1817161514 | --s-d-- | FEAT | Datomic-compatible data model and Datalog query engine inside PostgreSQL |
| bloom | 1817161514 | c-s-d-- | FEAT | bloom access method - signature file based index |
| pg_tle | 1817161514 | --sLd-- | LANG | Trusted Language Extensions for PostgreSQL |
| plv8 | 1817161514 | --s-d-- | LANG | PL/JavaScript (v8) trusted procedural language |
| pljs | 1817161514 | --s-d-- | LANG | PL/JS trusted procedural language |
| pllua | 1817161514 | --s-d-- | LANG | Lua as a procedural language |
| pllua | 1817161514 | --s-d-r | LANG | Hstore transform for Lua |
| pllua | 1817161514 | --s-d-- | LANG | Lua as an untrusted procedural language |
| pllua | 1817161514 | --s-d-r | LANG | Hstore transform for untrusted Lua |
| plprql | 1817161514 | --s-d-- | LANG | Use PRQL in PostgreSQL - Pipelined Relational Query Language |
| pldebugger | 1817161514 | --sLd-r | LANG | server-side support for debugging PL/pgSQL functions |
| plpgsql_check | 1817161514 | --s-d-- | LANG | Additional validation, profiling, and diagnostics for PL/pgSQL functions |
| plprofiler | 1817161514 | --sLd-r | LANG | server-side support for profiling PL/pgSQL functions |
| plsh | 1817161514 | --s-d-r | LANG | PL/sh procedural language |
| pljava | 1817161514 | --s-d-- | LANG | PL/Java procedural language |
| plr | 1817161514 | --s-d-- | LANG | load R interpreter and execute R script from within a database |
| plxslt | 1817161514 | --s-d-r | LANG | XSLT procedural language for PostgreSQL |
| pg_mockable | 1817161514 | ----d-- | LANG | Create mockable wrappers for PostgreSQL functions in tests |
| pgsqlmock | 1817161514 | ----d-r | LANG | Mocking and faking helpers for PostgreSQL unit tests |
| plx | 1817161514 | --s-d-r | LANG | Transpile multiple procedural dialects to PL/pgSQL |
| pgwasm | 1817161514 | --s-d-- | LANG | Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions. |
| plruby | 1817161514 | --s-d-- | LANG | Embed MRI Ruby as an untrusted PostgreSQL procedural language |
| plruby | 1817161514 | --s-d-r | LANG | Transform between jsonb and native Ruby data for PL/Ruby |
| plruby | 1817161514 | --s-d-r | LANG | Transform between hstore and Ruby Hashes for PL/Ruby |
| plruby | 1817161514 | --s-d-r | LANG | Transform between ltree and Ruby Arrays for PL/Ruby |
| pgtap | 1817161514 | --s-d-- | LANG | Unit testing for PostgreSQL |
| faker | 1817161514 | --s-d-- | LANG | Wrapper for the Faker Python library |
| dbt2 | 1817161514 | --s-d-r | LANG | OSDL-DBT-2 test kit |
| pg_regresql | 1817161514 | --sLd-r | LANG | Trust pg_class statistics for planning instead of physical relation size |
| pltcl | 1817161514 | c-s-dt- | LANG | PL/Tcl procedural language |
| pltcl | 1817161514 | c---d-- | LANG | PL/TclU untrusted procedural language |
| plperl | 1817161514 | c-s-dt- | LANG | PL/Perl procedural language |
| plperl | 1817161514 | c-s-dt- | LANG | transform between bool and plperl |
| plperl | 1817161514 | c-s-d-- | LANG | transform between hstore and plperl |
| plperl | 1817161514 | c---dt- | LANG | transform between jsonb and plperl |
| plperlu | 1817161514 | c-s-d-- | LANG | PL/PerlU untrusted procedural language |
| plperlu | 1817161514 | c---d-- | LANG | transform between bool and plperlu |
| plperlu | 1817161514 | c---d-- | LANG | transform between jsonb and plperlu |
| plperlu | 1817161514 | c---d-- | LANG | transform between hstore and plperlu |
| plpgsql | 1817161514 | c-s-dt- | LANG | PL/pgSQL procedural language |
| plpython3u | 1817161514 | c-s-d-- | LANG | PL/Python3U untrusted procedural language |
| plpython3u | 1817161514 | c---d-r | LANG | transform between jsonb and plpython3u |
| plpython3u | 1817161514 | c-s-d-r | LANG | transform between ltree and plpython3u |
| plpython3u | 1817161514 | c---d-r | LANG | transform between hstore and plpython3u |
| pg_prefix | 1817161514 | --s-d-r | TYPE | Prefix Range module for PostgreSQL |
| pg_semver | 1817161514 | --s-d-r | TYPE | Semantic version data type |
| pg_text_semver | 1817161514 | ----d-r | TYPE | Semantic version domain and comparison operators for PostgreSQL |
| pgunit | 1817161514 | --s-d-- | TYPE | SI units extension |
| pgpdf | 1817161514 | --sLdtr | TYPE | PDF type with meta admin & Full-Text Search |
| pglite_fusion | 1817161514 | --sLd-- | TYPE | Embed an SQLite database in your PostgreSQL table |
| md5hash | 1817161514 | --s-d-r | TYPE | type for storing 128-bit binary data inline |
| asn1oid | 1817161514 | --s-d-r | TYPE | asn1oid extension |
| pg_roaringbitmap | 1817161514 | --s-d-r | TYPE | support for Roaring Bitmaps |
| pgfaceting | 1817161514 | ----d-- | TYPE | fast faceting queries using an inverted index |
| pgsphere | 1817161514 | --s-d-r | TYPE | spherical objects with useful functions, operators and index support |
| pg_country | 1817161514 | --s-d-r | TYPE | Country data type, ISO 3166-1 |
| pg_xenophile | 1817161514 | ----d-- | TYPE | More than the bare necessities for PostgreSQL i18n and l10n. |
| pg_xenophile | 1817161514 | ----d-r | TYPE | PostgreSQL l10n toolbox |
| pg_currency | 1817161514 | --s-d-r | TYPE | Custom PostgreSQL currency type in 1Byte |
| pgcollection | 1817161514 | --s-d-r | TYPE | Memory optimized data type to be used inside of plpglsql func |
| pgmp | 1817161514 | --s-d-r | TYPE | Multiple Precision Arithmetic extension |
| numeral | 1817161514 | --s-d-r | TYPE | numeral datatypes extension |
| pg_rational | 1817161514 | --s-d-- | TYPE | bigint fractions |
| pguint | 1817161514 | --s-d-r | TYPE | unsigned integer types |
| pg_uint128 | 1817161514 | --s-d-r | TYPE | Native uint128 type |
| hashtypes | 1817161514 | --s-d-- | TYPE | sha1, md5 and other data types for PostgreSQL |
| postbis | 1817161514 | --s-d-r | TYPE | Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and |
| ip4r | 1817161514 | --s-d-r | TYPE | IPv4/v6 and IPv4/v6 range index type for PostgreSQL |
| pg_uri | 1817161514 | --s-d-r | TYPE | URI Data type for PostgreSQL |
| pg_emailaddr | 1817161514 | --s-d-- | TYPE | Email address type for PostgreSQL |
| pg_acl | 1817161514 | --s-d-r | TYPE | ACL Data type |
| debversion | 1817161514 | --s-d-r | TYPE | Debian version number data type |
| pg_duration | 1817161514 | --s-d-r | TYPE | data type for representing durations |
| pg_bikram_sambat | 1817161514 | --s-d-r | TYPE | Bikram Sambat date type and AD/BS conversion functions |
| pg_rrule | 1817161514 | --s-d-r | TYPE | RRULE field type for PostgreSQL |
| pgcalendar | 1817161514 | ----d-- | TYPE | Recurring calendar, schedule, and exception management for PostgreSQL |
| timestamp9 | 1817161514 | --s-d-- | TYPE | timestamp nanosecond resolution |
| pgbson | 1817161514 | --s-d-r | TYPE | BSON data type and accessor functions for PostgreSQL |
| chkpass | 1817161514 | --s-d-- | TYPE | data type for auto-encrypted passwords |
| isn | 1817161514 | c-s-dt- | TYPE | data types for international product numbering standards |
| seg | 1817161514 | c-s-dt- | TYPE | data type for representing line segments or floating-point intervals |
| cube | 1817161514 | c-s-dt- | TYPE | data type for multidimensional cubes |
| ltree | 1817161514 | c-s-dt- | TYPE | data type for hierarchical tree-like structures |
| hstore | 1817161514 | c-s-dt- | TYPE | data type for storing sets of (key, value) pairs |
| citext | 1817161514 | c-s-dt- | TYPE | data type for case-insensitive character strings |
| xml2 | 1817161514 | c---d-- | TYPE | XPath querying and XSLT |
| pg_gzip | 1817161514 | --s-d-r | UTIL | gzip and gunzip functions. |
| pg_bzip | 1817161514 | --s-d-- | UTIL | Bzip compression and decompression |
| pg_zstd | 1817161514 | --s-d-r | UTIL | Zstandard compression algorithm implementation in PostgreSQL |
| pg_http | 1817161514 | --s-d-- | UTIL | HTTP client for PostgreSQL, allows web page retrieval inside the database. |
| pg_net | 1817161514 | --sLd-- | UTIL | Async HTTP Requests |
| pg_curl | 1817161514 | --s-d-r | UTIL | Run curl actions for data transfer in URL syntax |
| pg_retry | 1817161514 | --s-d-r | UTIL | Retry SQL statements on transient errors with exponential backoff |
| pg_fsql | 1817161514 | --s-d-- | UTIL | Recursive SQL template engine with JSONB-driven execution |
| pg_protobuf | 1817161514 | --s-d-r | UTIL | Protobuf support for PostgreSQL |
| pgproto | 1817161514 | --s-d-r | UTIL | Native Protobuf parsing, mutation, indexing, and JSON conversion support |
| pglock | 1817161514 | ----d-- | UTIL | Lightweight distributed lock service inside PostgreSQL |
| pgjq | 1817161514 | --s-dtr | UTIL | Use jq in Postgres |
| pgjwt | 1817161514 | --s-d-- | UTIL | JSON Web Token API for Postgresql |
| pg_smtp_client | 1817161514 | --s-d-- | UTIL | PostgreSQL extension to send email using SMTP |
| pg_html5_email_address | 1817161514 | ----d-r | UTIL | PostgreSQL email validation that is consistent with the HTML5 spec |
| url_encode | 1817161514 | --s-d-r | UTIL | url_encode, url_decode functions |
| pgsql_tweaks | 1817161514 | --s-d-r | UTIL | Some functions and views for daily usage |
| pg_extra_time | 1817161514 | --s-d-r | UTIL | Some date time functions and operators that, |
| pgpcre | 1817161514 | --s-d-r | UTIL | Perl Compatible Regular Expression functions |
| re2 | 1817161514 | --s-dtr | UTIL | ClickHouse-compatible regex functions using RE2 |
| icu_ext | 1817161514 | --s-d-r | UTIL | Access ICU functions |
| pgqr | 1817161514 | --s-d-r | UTIL | QR Code generator from PostgreSQL |
| pg_envvar | 1817161514 | --s-d-- | UTIL | Fetch the value of an environment variable |
| pg_byteamagic | 1817161514 | --s-d-r | UTIL | Detect MIME types and file formats from PostgreSQL bytea values |
| floatfile | 1817161514 | --s-d-r | UTIL | Simple file storage for arrays of floats |
| external_file | 1817161514 | ----d-- | UTIL | Access external server-side files through PostgreSQL functions |
| pg_render | 1817161514 | --s-d-- | UTIL | Render HTML in SQL |
| pg_readme | 1817161514 | ----d-r | UTIL | Generate a Markdown README from PostgreSQL COMMENT objects |
| pg_readme | 1817161514 | ----d-r | UTIL | Fixture extension used to test pg_readme document generation |
| ddl_historization | 1817161514 | ----d-- | UTIL | Historize the ddl changes inside PostgreSQL database |
| data_historization | 1817161514 | ----dt- | UTIL | PLPGSQL Script to historize data in partitionned table |
| pg_schedoc | 1817161514 | ----d-- | UTIL | Cross documentation between Django and DBT projects |
| pg_isok | 1817161514 | ----d-- | UTIL | Query-based data integrity management and soft alerting for PostgreSQL |
| pg_describe | 1817161514 | --s-d-r | UTIL | Report a query’s parameters and result columns without executing it |
| pg_hashlib | 1817161514 | --s-d-r | UTIL | Stable hash functions for Postgres |
| pg_xxhash | 1817161514 | --s-dtr | UTIL | xxhash functions for PostgreSQL |
| shacrypt | 1817161514 | --s-d-r | UTIL | Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes |
| cryptint | 1817161514 | --s-d-r | UTIL | Encryption functions for int and bigint values |
| pg_ecdsa | 1817161514 | --s-d-r | UTIL | uECC bindings for Postgres |
| pgsparql | 1817161514 | ----d-- | UTIL | Query SPARQL datasource with SQL |
| pg_idkit | 1817161514 | --s-d-- | FUNC | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
| pgx_ulid | 1817161514 | --sLd-- | FUNC | ulid type and methods |
| pg_uuidv7 | 1817161514 | --s-d-r | FUNC | Create UUIDv7 values in postgres |
| pg_uuid_v8 | 1817161514 | --s-d-- | FUNC | UUID v8 generator with embedded timestamps for PostgreSQL |
| permuteseq | 1817161514 | --s-d-r | FUNC | Pseudo-randomly permute sequences with a format-preserving encryption on elements |
| pg_hashids | 1817161514 | --s-d-r | FUNC | Short unique id generator for PostgreSQL, using hashids |
| pg_slug_gen | 1817161514 | --s-d-r | FUNC | Generate cryptographically secure timestamp-based slugs |
| sequential_uuids | 1817161514 | --s-d-r | FUNC | generator of sequential UUIDs |
| pg_typeid | 1817161514 | --s-d-- | FUNC | Allows to use TypeIDs in Postgres natively |
| snowflake | 1817161514 | --s-d-- | FUNC | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL |
| topn | 1817161514 | --s-d-- | FUNC | type for top-n JSONB |
| quantile | 1817161514 | --s-d-- | FUNC | Quantile aggregation function |
| lower_quantile | 1817161514 | --s-d-- | FUNC | Lower quantile aggregate function |
| count_distinct | 1817161514 | --s-d-r | FUNC | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| omnisketch | 1817161514 | --s-d-r | FUNC | data structure for on-line agg of data into approximate sketch |
| ddsketch | 1817161514 | --s-d-r | FUNC | Provides ddsketch aggregate function |
| vasco | 1817161514 | --s-d-r | FUNC | discover hidden correlations in your data with MIC |
| pgxicor | 1817161514 | --s-dtr | FUNC | XI Correlation Coefficient in Postgres |
| pg_weighted_statistics | 1817161514 | --s-d-r | FUNC | High-performance weighted statistics functions for sparse data |
| datasketches | 1817161514 | --s-d-r | FUNC | Approximate analytics sketches and aggregates for PostgreSQL |
| fbsql | 1817161514 | ----d-- | FUNC | Closure-preserving formula-based statistical modeling in SQL |
| tdigest | 1817161514 | --s-d-r | FUNC | Provides tdigest aggregate function. |
| first_last_agg | 1817161514 | --s-d-r | FUNC | first() and last() aggregate functions |
| extra_window_functions | 1817161514 | --s-d-r | FUNC | Extra Window Functions for PostgreSQL |
| floatvec | 1817161514 | --s-d-r | FUNC | Math for vectors (arrays) of numbers |
| aggs_for_vecs | 1817161514 | --s-d-r | FUNC | Aggregate functions for array inputs |
| aggs_for_arrays | 1817161514 | --s-d-r | FUNC | Various functions for computing statistics on arrays of numbers |
| argm | 1817161514 | --s-d-r | FUNC | argmax, argmin, and anyold aggregate functions |
| pg_csv | 1817161514 | --s-d-r | FUNC | Flexible CSV processing for Postgres |
| pg_arraymath | 1817161514 | --s-d-r | FUNC | Array math and operators that work element by element on the contents of arrays |
| pg_math | 1817161514 | --s-d-r | FUNC | GSL statistical functions for postgresql |
| pg_random | 1817161514 | --s-d-r | FUNC | random data generator |
| pg_base36 | 1817161514 | --s-d-- | FUNC | Integer Base36 types |
| pg_base62 | 1817161514 | --s-d-- | FUNC | Base62 extension for PostgreSQL |
| pg_base58 | 1817161514 | --s-d-- | FUNC | Base58 Encoder/Decoder Extension for PostgreSQL |
| pg_financial | 1817161514 | --s-d-r | FUNC | Financial aggregate functions |
| pg_accumulator | 1817161514 | --s-d-- | FUNC | Accumulation registers for balance and turnover tracking in PostgreSQL |
| pg_convert | 1817161514 | --s-d-- | FUNC | conversion functions for spatial, routing and other specialized uses |
| parray_gin | 1817161514 | --s-d-r | FUNC | GIN index operator class and partial-match operators for text arrays |
| refint | 1817161514 | c-s-d-- | FUNC | functions for implementing referential integrity (obsolete) |
| autoinc | 1817161514 | c-s-d-- | FUNC | functions for autoincrementing fields |
| insert_username | 1817161514 | c-s-d-- | FUNC | functions for tracking who changed a table |
| moddatetime | 1817161514 | c-s-d-- | FUNC | functions for tracking last modification time |
| tsm_system_time | 1817161514 | c-s-dt- | FUNC | TABLESAMPLE method which accepts time in milliseconds as a limit |
| dict_xsyn | 1817161514 | c-s-d-- | FUNC | text search dictionary template for extended synonym processing |
| tsm_system_rows | 1817161514 | c-s-dt- | FUNC | TABLESAMPLE method which accepts number of rows as a limit |
| tcn | 1817161514 | c-s-dt- | FUNC | Triggered change notifications |
| uuid-ossp | 1817161514 | c-s-dt- | FUNC | generate universally unique identifiers (UUIDs) |
| btree_gist | 1817161514 | c-s-dt- | FUNC | support for indexing common datatypes in GiST |
| btree_gin | 1817161514 | c-s-dt- | FUNC | support for indexing common datatypes in GIN |
| intarray | 1817161514 | c---dt- | FUNC | functions, operators, and index support for 1-D arrays of integers |
| intagg | 1817161514 | c---d-- | FUNC | integer aggregator and enumerator (obsolete) |
| dict_int | 1817161514 | c-s-dt- | FUNC | text search dictionary template for integers |
| unaccent | 1817161514 | c-s-dt- | FUNC | text search dictionary that removes accents |
| pg_repack | 1817161514 | -bs-d-- | ADMIN | Reorganize tables in PostgreSQL databases with minimal locks |
| pg_rewrite | 1817161514 | --sLd-r | ADMIN | Tool allows read write to the table during the rewriting |
| pg_query_rewrite | 1817161514 | --sLd-- | ADMIN | Rewrite SQL statements with a PostgreSQL ProcessUtility hook |
| pg_squeeze | 1817161514 | --sLd-- | ADMIN | A tool to remove unused space from a relation. |
| pg_dirtyread | 1817161514 | --s-d-r | ADMIN | Read dead but unvacuumed rows from table |
| pgfincore | 1817161514 | --s-d-r | ADMIN | examine and manage the os buffer cache |
| pg_cooldown | 1817161514 | --s-d-r | ADMIN | remove buffered pages for specific relations |
| pg_ddlx | 1817161514 | --s-d-- | ADMIN | DDL eXtractor functions |
| pglinter | 1817161514 | --s-dt- | ADMIN | PostgreSQL Linting and Analysis Extension |
| pg_prioritize | 1817161514 | --s-d-r | ADMIN | get and set the priority of PostgreSQL backends |
| pg_checksums | 1817161514 | --s---r | ADMIN | Activate/deactivate/verify checksums in offline Postgres clusters |
| pg_readonly | 1817161514 | --sLd-- | ADMIN | cluster database read only |
| pgdd | 1817161514 | --s-d-- | ADMIN | Introspect pg data dictionary via standard SQL |
| pg_permissions | 1817161514 | --s-d-- | ADMIN | view object permissions and compare them with the desired state |
| pgautofailover | 1817161514 | --sLd-- | ADMIN | pg_auto_failover |
| pg_catcheck | 1817161514 | --s-d-- | ADMIN | Diagnosing system catalog corruption |
| preprepare | 1817161514 | --s-d-r | ADMIN | Pre Prepare your Statement server side |
| pg_upless | 1817161514 | ----dt- | ADMIN | Detect Useless UPDATE |
| pgcozy | 1817161514 | ----d-- | ADMIN | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. |
| pg_orphaned | 1817161514 | --s-d-- | ADMIN | Deal with orphaned files |
| pg_crash | 1817161514 | --sL--- | ADMIN | Send random signals to random processes |
| pg_cheat_funcs | 1817161514 | --s-d-r | ADMIN | Provides cheat (but useful) functions |
| pg_fio | 1817161514 | --s-d-r | ADMIN | PostgreSQL File I/O Functions |
| pg_qos | 1817161514 | --sLd-- | ADMIN | QoS resource governor extension for PostgreSQL sessions and queries |
| pg_pathcheck | 1817161514 | --sL--- | ADMIN | Validate planner Path trees for freed or corrupt memory |
| pgdisablelogerror | 1817161514 | --sLd-r | ADMIN | Disable selected SQLSTATE error codes from PostgreSQL server logging. |
| online_advisor | 1817161514 | --sLd-r | ADMIN | Suggest missing indexes and extended statistics online |
| pg_column_tetris | 1817161514 | ----d-- | ADMIN | Enforce optimal column alignment to minimize row padding |
| cat_tools | 1817161514 | ----d-- | ADMIN | Tools for interfacing with the PostgreSQL catalog |
| pg_savior | 1817161514 | --s-d-r | ADMIN | Postgres extension to save OOPS mistakes |
| safeupdate | 1817161514 | --sL--- | ADMIN | Require criteria for UPDATE and DELETE |
| pg_strict | 1817161514 | --sLd-- | ADMIN | Prevent dangerous UPDATE and DELETE without WHERE clause |
| pg_drop_events | 1817161514 | ----d-- | ADMIN | logs transaction ids of drop table, drop column, drop materialized view statements |
| table_log | 1817161514 | --s-d-- | ADMIN | record table modification logs and PITR for table/row |
| pgelog | 1817161514 | ----d-- | ADMIN | Extended logging via pseudo-autonomous transactions |
| pgagent | 1817161514 | --s-d-- | ADMIN | A PostgreSQL job scheduler |
| pg_prewarm | 1817161514 | c-sLd-- | ADMIN | prewarm relation data |
| pgpool | 1817161514 | ----d-- | ADMIN | Administrative functions for pgPool |
| pgpool | 1817161514 | ----d-- | ADMIN | recovery functions for pgpool-II for V4.3 |
| pgpool | 1817161514 | ----d-- | ADMIN | replacement for regclass |
| lo | 1817161514 | c-s-dt- | ADMIN | Large Object maintenance |
| basic_archive | 1817161514 | c-s---- | ADMIN | an example of an archive module |
| basebackup_to_shell | 1817161514 | c-s---- | ADMIN | adds a custom basebackup target called shell |
| old_snapshot | 1817161514 | c-s-d-- | ADMIN | utilities in support of old_snapshot_threshold |
| adminpack | 1817161514 | c-s-d-- | ADMIN | administrative functions for PostgreSQL |
| amcheck | 1817161514 | c-s-d-- | ADMIN | functions for verifying relation integrity |
| pg_surgery | 1817161514 | c-s-d-- | ADMIN | extension to perform surgery on a damaged relation |
| pg_profile | 1817161514 | --s-d-- | STAT | PostgreSQL load profile repository and report builder |
| pg_tracing | 1817161514 | --sLd-r | STAT | Distributed Tracing for PostgreSQL |
| pg_stat_ch | 1817161514 | --sLd-- | STAT | Export PostgreSQL query telemetry to ClickHouse |
| pg_stat_backtrace | 1817161514 | --s-d-r | STAT | Capture or log C-level stack backtraces of PostgreSQL processes |
| pg_stat_log | 1817161514 | --sLd-r | STAT | Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. |
| pg_stat_plans | 1817161514 | --sLd-r | STAT | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| pg_flight_recorder | 1817161514 | ----d-- | STAT | Server-side PostgreSQL performance flight recorder |
| pg_flight_recorder | 1817161514 | ----d-- | STAT | Reporting and analysis functions for pgfr_record |
| pgmonitor | 1817161514 | --sLd-- | STAT | Collector-friendly metric views and background refresh worker |
| pg_statviz | 1817161514 | ----d-- | STAT | Capture PostgreSQL statistics snapshots for time-series analysis and visualization |
| pg_show_plans | 1817161514 | --sLd-r | STAT | show query plans of all currently running SQL statements |
| pg_stat_kcache | 1817161514 | --sLd-r | STAT | Kernel statistics gathering |
| pg_stat_monitor | 1817161514 | --sLd-r | STAT | The pg_stat_monitor is a PostgreSQL Query Performance Monitoring tool, based on PostgreSQL contrib m |
| pg_qualstats | 1817161514 | --sLd-- | STAT | An extension collecting statistics about quals |
| pg_store_plans | 1817161514 | --sLd-r | STAT | track plan statistics of all SQL statements executed |
| pg_track_settings | 1817161514 | --s-d-- | STAT | Track settings changes |
| pg_track_optimizer | 1817161514 | --sLd-r | STAT | Track planning decisions in comparison with execution reality |
| pg_wait_sampling | 1817161514 | --sLd-r | STAT | sampling based statistics of wait events |
| pg_datasentinel | 1817161514 | --sLd-- | STAT | Observability and activity monitoring extension for PostgreSQL |
| pgsentinel | 1817161514 | --sLd-r | STAT | active session history |
| system_stats | 1817161514 | --s-d-r | STAT | EnterpriseDB system statistics for PostgreSQL |
| pg_meta | 1817161514 | ----d-- | STAT | Normalized, friendlier system catalog for PostgreSQL |
| pgnodemx | 1817161514 | --sLd-r | STAT | Capture node OS metrics via SQL queries |
| pgnodemx | 1817161514 | --s-d-r | STAT | PostgreSQL extension to access the OS process table |
| pg_sqlog | 1817161514 | --s-d-- | STAT | Provide SQL interface to logs |
| bgw_replstatus | 1817161514 | --sL--- | STAT | Small PostgreSQL background worker to report whether a node is a replication master or standby |
| pgmeminfo | 1817161514 | --s-d-- | STAT | show memory usage |
| toastinfo | 1817161514 | --s-d-r | STAT | show details on toasted datums |
| pg_explain_ui | 1817161514 | --s-d-- | STAT | easily jump into a visual plan UI for any SQL query |
| pg_relusage | 1817161514 | --sL--- | STAT | Log all the queries that reference a particular column |
| pagevis | 1817161514 | ----d-r | STAT | Visualise database pages in ascii code |
| powa | 1817161514 | --s-d-- | STAT | PostgreSQL Workload Analyser-core |
| pg_overexplain | 1817161514 | c-sL--- | STAT | Allow EXPLAIN to dump even more details |
| pg_logicalinspect | 1817161514 | c-s-d-- | STAT | Logical decoding components inspection |
| pageinspect | 1817161514 | c-s-d-- | STAT | inspect the contents of database pages at a low level |
| pgrowlocks | 1817161514 | c-s-d-- | STAT | show row-level locking information |
| sslinfo | 1817161514 | c-s-d-- | STAT | information about SSL certificates |
| pg_buffercache | 1817161514 | c-s-d-- | STAT | examine the shared buffer cache |
| pg_walinspect | 1817161514 | c-s-d-- | STAT | functions to inspect contents of PostgreSQL Write-Ahead Log |
| pg_freespacemap | 1817161514 | c-s-d-- | STAT | examine the free space map (FSM) |
| pg_visibility | 1817161514 | c-s-d-- | STAT | examine the visibility map (VM) and page-level visibility info |
| pgstattuple | 1817161514 | c-s-d-- | STAT | show tuple-level statistics |
| auto_explain | 1817161514 | c-sL--- | STAT | Provides a means for logging execution plans of slow statements automatically |
| pg_stat_statements | 1817161514 | c-sLd-- | STAT | track planning and execution statistics of all SQL statements executed |
| passwordcheck_cracklib | 1817161514 | --sL--- | SEC | Strengthen PostgreSQL user password checks with cracklib |
| supautils | 1817161514 | --sL--- | SEC | Extension that secures a cluster on a cloud environment |
| pgsodium | 1817161514 | --sLd-- | SEC | Postgres extension for libsodium functions |
| column_encrypt | 1817161514 | --sLd-- | SEC | Transparent column-level encryption with encrypted_text and encrypted_bytea types |
| passwordpolicy | 1817161514 | --sLd-r | SEC | Dynamically configurable PostgreSQL password complexity checks. |
| pg_vault | 1817161514 | --s-d-- | SEC | Supabase Vault Extension |
| pg_session_jwt | 1817161514 | --s-dt- | SEC | Manage authentication sessions using JWTs |
| pg_anon | 1817161514 | --sLd-- | SEC | PostgreSQL Anonymizer (anon) extension |
| pgsmcrypto | 1817161514 | --s-d-- | SEC | PostgreSQL SM Algorithm Extension |
| pg_enigma | 1817161514 | --s-d-- | SEC | Encrypted postgres data type |
| pgaudit | 1817161514 | --sLd-r | SEC | provides auditing functionality |
| pgauditlogtofile | 1817161514 | --sLd-r | SEC | pgAudit addon to redirect audit log to an independent file |
| pg_roast | 1817161514 | --sLd-- | SEC | Opinionated PostgreSQL database auditor |
| pg_auditor | 1817161514 | ----d-- | SEC | Audit data changes and provide flashback ability |
| logerrors | 1817161514 | --sLd-r | SEC | Function for collecting statistics about messages in logfile |
| pg_auth_mon | 1817161514 | --sLd-r | SEC | monitor connection attempts per user |
| pg_jobmon | 1817161514 | --s-d-- | SEC | Extension for logging and monitoring functions in PostgreSQL |
| pg_oidc_validator | 1817161514 | --sL--- | SEC | OAuth and OIDC token validator for PostgreSQL 18 |
| pg_oidc_validator_rust | 1817161514 | --sL--- | SEC | PostgreSQL 18 OIDC bearer-token validator plugin written in Rust |
| pgmemento | 1817161514 | ----d-- | SEC | Transaction-based audit trail with schema versioning |
| credcheck | 1817161514 | --sLd-- | SEC | credcheck - postgresql plain text credential checker |
| pgcryptokey | 1817161514 | --s-d-r | SEC | cryptographic key management |
| pg_pwhash | 1817161514 | --s-d-r | SEC | Advanced password hashing methods for PostgreSQL |
| login_hook | 1817161514 | --s-d-- | SEC | login_hook - hook to execute login_hook.login() at login time |
| set_user | 1817161514 | --sLd-- | SEC | similar to SET ROLE but with added logging |
| pg_snakeoil | 1817161514 | --sLd-r | SEC | The PostgreSQL Antivirus |
| pgextwlist | 1817161514 | --sL--- | SEC | PostgreSQL Extension Whitelisting |
| pg_command_fw | 1817161514 | --sLd-- | SEC | DDL and utility command firewall for PostgreSQL |
| sslutils | 1817161514 | --s-d-- | SEC | A Postgres extension for managing SSL certificates through SQL |
| pg_noset | 1817161514 | --sLd-r | SEC | Module for blocking SET variables for non-super users. |
| block_copy_command | 1817161514 | --sLd-- | SEC | Block COPY commands via a configurable ProcessUtility hook |
| pg_policy | 1817161514 | ----d-- | SEC | Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls |
| pg_kpart | 1817161514 | --sL--r | SEC | Reject full partition scans that omit the partition key |
| pg_tde | 1817161514 | --sLd-- | SEC | Percona pg_tde access method |
| pg_vault_tde | 1817161514 | -bsLd-- | SEC | Transparent Data Encryption for PostgreSQL through custom table and index access methods |
| sepgsql | 1817161514 | c-sL--- | SEC | label-based mandatory access control (MAC) based on SELinux security policy. |
| auth_delay | 1817161514 | c-sL--- | SEC | pause briefly before reporting authentication failure |
| pgcrypto | 1817161514 | c-s-dt- | SEC | cryptographic functions |
| passwordcheck | 1817161514 | c-sL--- | SEC | checks user passwords and reject weak password |
| wrappers | 1817161514 | --s-d-r | FDW | Foreign data wrappers developed by Supabase |
| multicorn | 1817161514 | --s-d-- | FDW | Fetch foreign data in Python in your PostgreSQL server. |
| odbc_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for accessing remote databases using ODBC |
| jdbc_fdw | 1817161514 | --s-d-r | FDW | foreign-data wrapper for remote servers available over JDBC |
| pgspider_ext | 1817161514 | --s-d-r | FDW | foreign-data wrapper for remote PGSpider servers |
| mysql_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for querying a MySQL server |
| oracle_fdw | 1817161514 | --s-d-- | FDW | foreign data wrapper for Oracle access |
| tds_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
| db2_fdw | 1817161514 | --s-d-- | FDW | foreign data wrapper for DB2 access |
| sqlite_fdw | 1817161514 | --s-d-r | FDW | SQLite Foreign Data Wrapper |
| pgbouncer_fdw | 1817161514 | ----d-- | FDW | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from norma |
| etcd_fdw | 1817161514 | --s-d-- | FDW | Foreign data wrapper for etcd |
| informix_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for Informix access |
| nominatim_fdw | 1817161514 | --s-d-r | FDW | Nominatim Foreign Data Wrapper for PostgreSQL |
| mongo_fdw | 1817161514 | --s-d-- | FDW | foreign data wrapper for MongoDB access |
| redis_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for querying a Redis server |
| pg_redis_pubsub | 1817161514 | --s-d-r | FDW | Send redis pub/sub messages to Redis from PostgreSQL Directly |
| kafka_fdw | 1817161514 | --s-d-r | FDW | kafka Foreign Data Wrapper for CSV formatted messages |
| hdfs_fdw | 1817161514 | --s-d-r | FDW | foreign-data wrapper for remote hdfs servers |
| firebird_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for Firebird |
| rdf_fdw | 1817161514 | --s-d-r | FDW | Foreign data wrapper for RDF triplestores over SPARQL endpoints |
| aws_s3 | 1817161514 | ----d-r | FDW | aws_s3 postgres extension to import/export data from/to s3 |
| log_fdw | 1817161514 | --s-d-- | FDW | foreign-data wrapper for Postgres log file access |
| dblink | 1817161514 | c-s-d-- | FDW | connect to other PostgreSQL databases from within a database |
| file_fdw | 1817161514 | c-s-d-- | FDW | foreign-data wrapper for flat file access |
| postgres_fdw | 1817161514 | c-s-d-- | FDW | foreign-data wrapper for remote PostgreSQL servers |
| documentdb | 1817161514 | --sLd-- | SIM | API surface for DocumentDB for PostgreSQL |
| documentdb | 1817161514 | --sLd-- | SIM | Core API surface for DocumentDB on PostgreSQL |
| documentdb | 1817161514 | --sLd-- | SIM | Multi-Node API surface for DocumentDB |
| documentdb | 1817161514 | --sLd-r | SIM | DocumentDB Extended RUM index access method |
| pg_projection | 1817161514 | ----d-r | SIM | MongoDB-like read projections for JSONB in PostgreSQL |
| orafce | 1817161514 | --s-d-- | SIM | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| pgtt | 1817161514 | --sLd-- | SIM | Extension to add Global Temporary Tables feature to PostgreSQL |
| session_variable | 1817161514 | --s-d-- | SIM | Registration and manipulation of session variables and constants |
| pg_statement_rollback | 1817161514 | --sL--- | SIM | Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
| ivorysql | 1817161514 | --s-d-- | SIM | Oracle Compatible extension on Postgres Database |
| ivorysql | 1817161514 | --s-dt- | SIM | Support for indexing oracle datatypes in GIN |
| ivorysql | 1817161514 | --s-dt- | SIM | Support for oracle indexing common datatypes in GiST |
| ivorysql | 1817161514 | --s-dt- | SIM | Get function’s definition |
| ivorysql | 1817161514 | --s-dt- | SIM | PL/iSQL procedural language |
| ivorysql | 1817161514 | --s-dt- | SIM | Support GB18030-2022 and UTF-8 conversion |
| db2fce | 1817161514 | ----d-- | SIM | DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL. |
| plpgsql_wrap | 1817161514 | --s-d-- | SIM | Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. |
| pg_dbms_metadata | 1817161514 | ----d-- | SIM | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
| pg_dbms_lock | 1817161514 | ----d-- | SIM | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
| pg_dbms_job | 1817161514 | --sLd-- | SIM | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
| pg_dbms_errlog | 1817161514 | --sLd-- | SIM | Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. |
| pg_utl_smtp | 1817161514 | ----d-- | SIM | Oracle UTL_SMTP compatibility extension for PostgreSQL |
| babelfish | 1817161514 | --s-d-r | SIM | SQL Server Transact SQL Datatype Support |
| babelfish | 1817161514 | --s-d-r | SIM | SQL Server Transact SQL compatibility |
| babelfish | 1817161514 | --sLd-r | SIM | SQL Server TDS protocol extension |
| babelfish | 1817161514 | --s-dt- | SIM | SQL Server Money Data Type |
| pgmemcache | 1817161514 | --s-d-r | SIM | memcached interface |
| openhalo | 1817161514 | --s-d-- | SIM | MySQL Supplementary Extension |
| pglogical | 1817161514 | --sLd-- | ETL | PostgreSQL Logical Replication |
| pglogical | 1817161514 | --s-d-- | ETL | Dummy extension for compatibility when upgrading from Postgres 9.4 |
| pglogical_ticker | 1817161514 | --sLd-- | ETL | Have an accurate view on pglogical replication delay |
| pgl_ddl_deploy | 1817161514 | --s-d-- | ETL | automated ddl deployment using pglogical |
| logical_ddl | 1817161514 | --s-d-- | ETL | Replicate supported DDL changes over PostgreSQL logical replication |
| pg_failover_slots | 1817161514 | --sL--r | ETL | PG Failover Slots extension |
| db_migrator | 1817161514 | ----d-r | ETL | Tools to migrate other databases to PostgreSQL |
| pgactive | 1817161514 | -bsLd-- | ETL | Active-Active Replication Extension for PostgreSQL |
| spock | 1817161514 | -bsLd-- | ETL | Multi-master logical replication extension for PostgreSQL |
| lolor | 1817161514 | --s-dt- | ETL | Logical-replication-friendly replacement for PostgreSQL large objects |
| pgclone | 1817161514 | --sLd-- | ETL | Clone PostgreSQL databases, schemas, tables, and functions across environments |
| pgmqtt | 1817161514 | --s-d-- | ETL | CDC-to-MQTT broker for PostgreSQL |
| wal2json | 1817161514 | --s---- | ETL | Changing data capture in JSON format |
| wal2mongo | 1817161514 | --s---- | ETL | PostgreSQL logical decoding output plugin for MongoDB |
| decoderbufs | 1817161514 | --sL--- | ETL | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| decoder_raw | 1817161514 | --s---- | ETL | Output plugin for logical replication in Raw SQL format |
| mimeo | 1817161514 | ----d-- | ETL | Extension for specialized, per-table replication between PostgreSQL instances |
| repmgr | 1817161514 | --sLd-- | ETL | Replication manager for PostgreSQL |
| pg_fact_loader | 1817161514 | --s-d-- | ETL | build fact tables with Postgres |
| pg_bulkload | 1817161514 | -bs-d-- | ETL | pg_bulkload is a high speed data loading utility for PostgreSQL |
| test_decoding | 1817161514 | c-s---- | ETL | SQL-based test/example module for WAL logical decoding |
| pgoutput | 1817161514 | c-s---- | ETL | Logical Replication output plugin |
Attribute Legend: c:contrib b:bin s:lib l:load d:ddl t:trusted r:relocatable
Enables scalable inserts and complex queries for time-series data
Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities
Convenience API for time series stack
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal tables
Enables fine-grained write logging and time travel on subsets of the database.
PostgreSQL table versioning extension
Job scheduler for PostgreSQL
execute any sql command at any specific time at background
Run queries now and get results later
Asynchronous SQL dispatcher built on pg_cron
Run SQL queries in the background
Natural language time parsing for PostgreSQL
Time series analysis functions for PostgreSQL
Parse cron expressions and compute previous or next trigger times
PostGIS geometry and geography spatial types and functions
PostGIS topology spatial types and functions
PostGIS raster types and functions
PostGIS SFCGAL functions
PostGIS tiger geocoder and reverse geocoder
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
Address Standardizer US dataset example
pgRouting Extension
data type for lidar point clouds
integration for pointcloud LIDAR data and PostGIS geometry data
H3 bindings for PostgreSQL
H3 PostGIS integration
q3c sky indexing plugin
foreign-data wrapper for GIS data access
IP-based geolocation query
Fast Google Encoded Polyline encoding & decoding for postgres
Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform
Handle geohash based functionality for spatial coordinates
Drainage network analysis core for PostgreSQL and PostGIS
Raster hydrology extension for PgHydro
Hydrogeomorphological analysis extension for PgHydro
Output and reporting objects for PgHydro
Australian English output pack for PgHydro
Brazilian Portuguese output pack for PgHydro
Pfafstetter consistency checks for PgHydro
MobilityDB geospatial trajectory data management & analysis platform
MobilityDB random data generator functions
Fast lookup timezone name by GPS coordinates
calculate great-circle distances on the surface of the Earth
Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL.
Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC.
vector data type and ivfflat and hnsw access methods
Vector database plugin for Postgres, written in Rust
Advanced indexing for vector data with DiskANN
The simplest way to do vector search on Postgres
support similarity queries
Reciprocal rank fusion functions for hybrid search
Effective similarity search
Text Summarization using LLMs. Built using pgrx
tiktoken tokenizer for use with OpenAI models in postgres
Fast tiktoken BPE tokenizer for PostgreSQL implemented in C
Machine learning framework for PostgreSQL
Run AL/ML workloads with SQL interface
Single-plan multimodal agent memory for PostgreSQL
Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables.
Optional pgvector compatibility bridge for pgcontext HNSW indexes.
TurboQuant-compressed vector type and ANN index access method for PostgreSQL.
Full text search for PostgreSQL using BM25
Use Groonga as index, fast full text search platform for all languages!
PGroonga database management module
create 2-gram (bigram) index for faster full text search.
a parser for full-text search of Chinese
Generate BM25 sparse vector inside PostgreSQL
A postgresql extension for bm25 ranking algorithm
Tokenizers for full-text search
IAM-LIKE pattern matching with bitmap indexing
Full-text search with BM25 ranking
Pinyin romanization and search helpers for PostgreSQL
Kazakh full-text search extension for PostgreSQL
PostgreSQL extension for BM25-family lexical retrieval
Full-text search with BM25 and BM25F ranking
CJK bigram parser derived from PostgreSQL full-text search
Chinese full-text search parser based on cppjieba
Czech Hunspell Dictionary
German Hunspell Dictionary
en_US Hunspell Dictionary
French Hunspell Dictionary
Nepali Hunspell Dictionary
Dutch Hunspell Dictionary
Norwegian (norsk) Hunspell Dictionary
Portuguese Hunspell Dictionary
Russian Hunspell Dictionary
Russian Hunspell Dictionary (from AOT.ru group)
determine similarities and distance between strings
text similarity measurement and index searching based on trigrams
Distributed PostgreSQL as an extension
Citus columnar storage engine
Hydra Columnar extension
Postgres for analytics, powered by DuckDB
DuckDB Embedded in Postgres
Columnstore Table in Postgres
colcompress and rowcompress Table Access Methods with vectorized execution
Interfaces to query ClickHouse databases from PostgreSQL
DuckDB Foreign Data Wrapper
copy data between Postgres and Parquet
DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet
Table partitioning by foreign key utility
Extension to manage partitioned tables by time or ID
Database partitioning implemented as procedural language
PG-Strom - big-data processing acceleration using GPU and NVME
ORCA query optimizer as a PostgreSQL extension
Sorted heap table AM with zone map scan pruning and built-in vector search
Data lake extension by Snowflake
Extension development kit by Snowflake
Automatic extension updater
Map type for PostgreSQL, bundled as a required pg_lake component.
Query engine for data lake queries
Iceberg implementation in Postgres
Data lake tables and Iceberg tables
Copy to/from data lake files
functions that manipulate whole tables, including crosstab
AGE graph database extension
Liquid-inspired Datalog graph query extension for PostgreSQL
Sparse linear algebra and graph extension for PostgreSQL 18
Graph database capabilities for PostgreSQL
RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL
Generic queue for PostgreSQL
A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
A simple PostgreSQL Message Broker system
Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery
Finite state machine toolkit for PostgreSQL
type for storing hyperloglog data
RUM index access method
AI-powered SQL query generation for PostgreSQL
Automatic data expiration with TTL indexes
Add in-database GraphQL support
PostgreSQL extension providing JSON Schema validation
JSON Schema validation functions for PostgreSQL
data type for jsonb inspection
Give PostgreSQL ability to manually force some decisions in execution plans.
Hypothetical indexes for PostgreSQL
Query index advisor
filter statements by their execution plans.
Session-scoped variables with scalar, array, and record types
Image similarity with haar
incremental view maintenance on PostgreSQL
Incremental Processing by Crunchy Data
Streaming tables and differential view maintenance for PostgreSQL 18
Durable SQL functions for PostgreSQL
Perturb unordered SELECT row order to expose order-dependent tests
Transaction-aware shared-memory cache for ordinary PostgreSQL primary-key reads
Semiring provenance and probability management for PostgreSQL
OrioleDB, the next generation transactional engine
A suite of Cardano-related tools
Cheminformatics functionality for PostgreSQL.
Advanced adapter for Postgres extensions
Basic session management
Amazon Web Services APIs (S3)
CloudEvents support
Docker container management
Application credential management
CSV toolkit
Dataset provisioning
E-mail framework
Basic HTTP types
HTTP client
HTTP server
Identity types
JSON toolkit
Kubernetes (k8s) integration
Financial ledger
Package installation manifests
MIME types
Operating system integration
Postgres API polyfills
First-class Python support
PCRE-compatible regular expressions
REST API toolkit (with PostgREST support)
Advanced schema management tooling
Distributed integer sequences
Service management
Session management
Shared Memory Management
Programmatic SQL manipulation
Embedded SQLite
Testing framework
Transaction management
Advanced types
Scoped variables
Virtual File System
Virtual File System types (v1)
Common web stack primitives
Generalized worker pool
XML toolkit
YAML toolkit
Datomic-compatible data model and Datalog query engine inside PostgreSQL
bloom access method - signature file based index
Trusted Language Extensions for PostgreSQL
PL/JavaScript (v8) trusted procedural language
PL/JS trusted procedural language
Lua as a procedural language
Hstore transform for Lua
Lua as an untrusted procedural language
Hstore transform for untrusted Lua
Use PRQL in PostgreSQL - Pipelined Relational Query Language
server-side support for debugging PL/pgSQL functions
Additional validation, profiling, and diagnostics for PL/pgSQL functions
server-side support for profiling PL/pgSQL functions
PL/sh procedural language
PL/Java procedural language
load R interpreter and execute R script from within a database
XSLT procedural language for PostgreSQL
Create mockable wrappers for PostgreSQL functions in tests
Mocking and faking helpers for PostgreSQL unit tests
Transpile multiple procedural dialects to PL/pgSQL
Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions.
Embed MRI Ruby as an untrusted PostgreSQL procedural language
Transform between jsonb and native Ruby data for PL/Ruby
Transform between hstore and Ruby Hashes for PL/Ruby
Transform between ltree and Ruby Arrays for PL/Ruby
Unit testing for PostgreSQL
Wrapper for the Faker Python library
OSDL-DBT-2 test kit
Trust pg_class statistics for planning instead of physical relation size
PL/Tcl procedural language
PL/TclU untrusted procedural language
PL/Perl procedural language
transform between bool and plperl
transform between hstore and plperl
transform between jsonb and plperl
PL/PerlU untrusted procedural language
transform between bool and plperlu
transform between jsonb and plperlu
transform between hstore and plperlu
PL/pgSQL procedural language
PL/Python3U untrusted procedural language
transform between jsonb and plpython3u
transform between ltree and plpython3u
transform between hstore and plpython3u
Prefix Range module for PostgreSQL
Semantic version data type
Semantic version domain and comparison operators for PostgreSQL
SI units extension
PDF type with meta admin & Full-Text Search
Embed an SQLite database in your PostgreSQL table
type for storing 128-bit binary data inline
asn1oid extension
support for Roaring Bitmaps
fast faceting queries using an inverted index
spherical objects with useful functions, operators and index support
Country data type, ISO 3166-1
More than the bare necessities for PostgreSQL i18n and l10n.
PostgreSQL l10n toolbox
Custom PostgreSQL currency type in 1Byte
Memory optimized data type to be used inside of plpglsql func
Multiple Precision Arithmetic extension
numeral datatypes extension
bigint fractions
unsigned integer types
Native uint128 type
sha1, md5 and other data types for PostgreSQL
Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions.
IPv4/v6 and IPv4/v6 range index type for PostgreSQL
URI Data type for PostgreSQL
Email address type for PostgreSQL
ACL Data type
Debian version number data type
data type for representing durations
Bikram Sambat date type and AD/BS conversion functions
RRULE field type for PostgreSQL
Recurring calendar, schedule, and exception management for PostgreSQL
timestamp nanosecond resolution
BSON data type and accessor functions for PostgreSQL
data type for auto-encrypted passwords
data types for international product numbering standards
data type for representing line segments or floating-point intervals
data type for multidimensional cubes
data type for hierarchical tree-like structures
data type for storing sets of (key, value) pairs
data type for case-insensitive character strings
XPath querying and XSLT
gzip and gunzip functions.
Bzip compression and decompression
Zstandard compression algorithm implementation in PostgreSQL
HTTP client for PostgreSQL, allows web page retrieval inside the database.
Async HTTP Requests
Run curl actions for data transfer in URL syntax
Retry SQL statements on transient errors with exponential backoff
Recursive SQL template engine with JSONB-driven execution
Protobuf support for PostgreSQL
Native Protobuf parsing, mutation, indexing, and JSON conversion support
Lightweight distributed lock service inside PostgreSQL
Use jq in Postgres
JSON Web Token API for Postgresql
PostgreSQL extension to send email using SMTP
PostgreSQL email validation that is consistent with the HTML5 spec
url_encode, url_decode functions
Some functions and views for daily usage
Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations
Some date time functions and operators that,
Perl Compatible Regular Expression functions
ClickHouse-compatible regex functions using RE2
Access ICU functions
QR Code generator from PostgreSQL
Fetch the value of an environment variable
Detect MIME types and file formats from PostgreSQL bytea values
Simple file storage for arrays of floats
Access external server-side files through PostgreSQL functions
Render HTML in SQL
Generate a Markdown README from PostgreSQL COMMENT objects
Fixture extension used to test pg_readme document generation
Historize the ddl changes inside PostgreSQL database
PLPGSQL Script to historize data in partitionned table
Cross documentation between Django and DBT projects
Query-based data integrity management and soft alerting for PostgreSQL
Report a query’s parameters and result columns without executing it
Stable hash functions for Postgres
xxhash functions for PostgreSQL
Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes
Encryption functions for int and bigint values
uECC bindings for Postgres
Query SPARQL datasource with SQL
multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID)
ulid type and methods
Create UUIDv7 values in postgres
UUID v8 generator with embedded timestamps for PostgreSQL
Pseudo-randomly permute sequences with a format-preserving encryption on elements
Short unique id generator for PostgreSQL, using hashids
Generate cryptographically secure timestamp-based slugs
generator of sequential UUIDs
Allows to use TypeIDs in Postgres natively
Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL
type for top-n JSONB
Quantile aggregation function
Lower quantile aggregate function
An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate
data structure for on-line agg of data into approximate sketch
Provides ddsketch aggregate function
discover hidden correlations in your data with MIC
XI Correlation Coefficient in Postgres
High-performance weighted statistics functions for sparse data
Approximate analytics sketches and aggregates for PostgreSQL
Closure-preserving formula-based statistical modeling in SQL
Provides tdigest aggregate function.
first() and last() aggregate functions
Extra Window Functions for PostgreSQL
Math for vectors (arrays) of numbers
Aggregate functions for array inputs
Various functions for computing statistics on arrays of numbers
argmax, argmin, and anyold aggregate functions
Flexible CSV processing for Postgres
Array math and operators that work element by element on the contents of arrays
GSL statistical functions for postgresql
random data generator
Integer Base36 types
Base62 extension for PostgreSQL
Base58 Encoder/Decoder Extension for PostgreSQL
Financial aggregate functions
Accumulation registers for balance and turnover tracking in PostgreSQL
conversion functions for spatial, routing and other specialized uses
GIN index operator class and partial-match operators for text arrays
functions for implementing referential integrity (obsolete)
functions for autoincrementing fields
functions for tracking who changed a table
functions for tracking last modification time
TABLESAMPLE method which accepts time in milliseconds as a limit
text search dictionary template for extended synonym processing
TABLESAMPLE method which accepts number of rows as a limit
Triggered change notifications
generate universally unique identifiers (UUIDs)
support for indexing common datatypes in GiST
support for indexing common datatypes in GIN
functions, operators, and index support for 1-D arrays of integers
integer aggregator and enumerator (obsolete)
text search dictionary template for integers
text search dictionary that removes accents
Reorganize tables in PostgreSQL databases with minimal locks
Tool allows read write to the table during the rewriting
Rewrite SQL statements with a PostgreSQL ProcessUtility hook
A tool to remove unused space from a relation.
Read dead but unvacuumed rows from table
examine and manage the os buffer cache
remove buffered pages for specific relations
DDL eXtractor functions
PostgreSQL Linting and Analysis Extension
get and set the priority of PostgreSQL backends
Activate/deactivate/verify checksums in offline Postgres clusters
cluster database read only
Introspect pg data dictionary via standard SQL
view object permissions and compare them with the desired state
pg_auto_failover
Diagnosing system catalog corruption
Pre Prepare your Statement server side
Detect Useless UPDATE
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
Deal with orphaned files
Send random signals to random processes
Provides cheat (but useful) functions
PostgreSQL File I/O Functions
QoS resource governor extension for PostgreSQL sessions and queries
Validate planner Path trees for freed or corrupt memory
Disable selected SQLSTATE error codes from PostgreSQL server logging.
Suggest missing indexes and extended statistics online
Enforce optimal column alignment to minimize row padding
Tools for interfacing with the PostgreSQL catalog
Postgres extension to save OOPS mistakes
Require criteria for UPDATE and DELETE
Prevent dangerous UPDATE and DELETE without WHERE clause
logs transaction ids of drop table, drop column, drop materialized view statements
record table modification logs and PITR for table/row
Extended logging via pseudo-autonomous transactions
A PostgreSQL job scheduler
prewarm relation data
Administrative functions for pgPool
recovery functions for pgpool-II for V4.3
replacement for regclass
Large Object maintenance
an example of an archive module
adds a custom basebackup target called shell
utilities in support of old_snapshot_threshold
administrative functions for PostgreSQL
functions for verifying relation integrity
extension to perform surgery on a damaged relation
PostgreSQL load profile repository and report builder
Distributed Tracing for PostgreSQL
Export PostgreSQL query telemetry to ClickHouse
Capture or log C-level stack backtraces of PostgreSQL processes
Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
Track per-plan call counts, execution times, and example EXPLAIN texts.
Server-side PostgreSQL performance flight recorder
Reporting and analysis functions for pgfr_record
Collector-friendly metric views and background refresh worker
Capture PostgreSQL statistics snapshots for time-series analysis and visualization
show query plans of all currently running SQL statements
Kernel statistics gathering
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.
An extension collecting statistics about quals
track plan statistics of all SQL statements executed
Track settings changes
Track planning decisions in comparison with execution reality
sampling based statistics of wait events
Observability and activity monitoring extension for PostgreSQL
active session history
EnterpriseDB system statistics for PostgreSQL
Normalized, friendlier system catalog for PostgreSQL
Capture node OS metrics via SQL queries
PostgreSQL extension to access the OS process table
Provide SQL interface to logs
Small PostgreSQL background worker to report whether a node is a replication master or standby
show memory usage
show details on toasted datums
easily jump into a visual plan UI for any SQL query
Log all the queries that reference a particular column
Visualise database pages in ascii code
PostgreSQL Workload Analyser-core
Allow EXPLAIN to dump even more details
Logical decoding components inspection
inspect the contents of database pages at a low level
show row-level locking information
information about SSL certificates
examine the shared buffer cache
functions to inspect contents of PostgreSQL Write-Ahead Log
examine the free space map (FSM)
examine the visibility map (VM) and page-level visibility info
show tuple-level statistics
Provides a means for logging execution plans of slow statements automatically
track planning and execution statistics of all SQL statements executed
Strengthen PostgreSQL user password checks with cracklib
Extension that secures a cluster on a cloud environment
Postgres extension for libsodium functions
Transparent column-level encryption with encrypted_text and encrypted_bytea types
Dynamically configurable PostgreSQL password complexity checks.
Supabase Vault Extension
Manage authentication sessions using JWTs
PostgreSQL Anonymizer (anon) extension
PostgreSQL SM Algorithm Extension
Encrypted postgres data type
provides auditing functionality
pgAudit addon to redirect audit log to an independent file
Opinionated PostgreSQL database auditor
Audit data changes and provide flashback ability
Function for collecting statistics about messages in logfile
monitor connection attempts per user
Extension for logging and monitoring functions in PostgreSQL
OAuth and OIDC token validator for PostgreSQL 18
PostgreSQL 18 OIDC bearer-token validator plugin written in Rust
Transaction-based audit trail with schema versioning
credcheck - postgresql plain text credential checker
cryptographic key management
Advanced password hashing methods for PostgreSQL
login_hook - hook to execute login_hook.login() at login time
similar to SET ROLE but with added logging
The PostgreSQL Antivirus
PostgreSQL Extension Whitelisting
DDL and utility command firewall for PostgreSQL
A Postgres extension for managing SSL certificates through SQL
Module for blocking SET variables for non-super users.
Block COPY commands via a configurable ProcessUtility hook
Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls
Reject full partition scans that omit the partition key
Percona pg_tde access method
Transparent Data Encryption for PostgreSQL through custom table and index access methods
label-based mandatory access control (MAC) based on SELinux security policy.
pause briefly before reporting authentication failure
cryptographic functions
checks user passwords and reject weak password
Foreign data wrappers developed by Supabase
Fetch foreign data in Python in your PostgreSQL server.
Foreign data wrapper for accessing remote databases using ODBC
foreign-data wrapper for remote servers available over JDBC
foreign-data wrapper for remote PGSpider servers
Foreign data wrapper for querying a MySQL server
foreign data wrapper for Oracle access
Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
foreign data wrapper for DB2 access
SQLite Foreign Data Wrapper
Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions
Foreign data wrapper for etcd
Foreign data wrapper for Informix access
Nominatim Foreign Data Wrapper for PostgreSQL
foreign data wrapper for MongoDB access
Foreign data wrapper for querying a Redis server
Send redis pub/sub messages to Redis from PostgreSQL Directly
kafka Foreign Data Wrapper for CSV formatted messages
foreign-data wrapper for remote hdfs servers
Foreign data wrapper for Firebird
Foreign data wrapper for RDF triplestores over SPARQL endpoints
aws_s3 postgres extension to import/export data from/to s3
foreign-data wrapper for Postgres log file access
connect to other PostgreSQL databases from within a database
foreign-data wrapper for flat file access
foreign-data wrapper for remote PostgreSQL servers
API surface for DocumentDB for PostgreSQL
Core API surface for DocumentDB on PostgreSQL
Multi-Node API surface for DocumentDB
DocumentDB Extended RUM index access method
MongoDB-like read projections for JSONB in PostgreSQL
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
Extension to add Global Temporary Tables feature to PostgreSQL
Registration and manipulation of session variables and constants
Server side rollback at statement level for PostgreSQL like Oracle or DB2
Oracle Compatible extension on Postgres Database
Support for indexing oracle datatypes in GIN
Support for oracle indexing common datatypes in GiST
Get function’s definition
PL/iSQL procedural language
Support GB18030-2022 and UTF-8 conversion
DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL
Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL
Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
Oracle UTL_SMTP compatibility extension for PostgreSQL
SQL Server Transact SQL Datatype Support
SQL Server Transact SQL compatibility
SQL Server TDS protocol extension
SQL Server Money Data Type
Redis-like In-Memory DB Embedded in Postgres
memcached interface
MySQL Supplementary Extension
PostgreSQL Logical Replication
Dummy extension for compatibility when upgrading from Postgres 9.4
Have an accurate view on pglogical replication delay
automated ddl deployment using pglogical
Replicate supported DDL changes over PostgreSQL logical replication
PG Failover Slots extension
Tools to migrate other databases to PostgreSQL
Active-Active Replication Extension for PostgreSQL
Multi-master logical replication extension for PostgreSQL
Logical-replication-friendly replacement for PostgreSQL large objects
Clone PostgreSQL databases, schemas, tables, and functions across environments
CDC-to-MQTT broker for PostgreSQL
Changing data capture in JSON format
PostgreSQL logical decoding output plugin for MongoDB
Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
Output plugin for logical replication in Raw SQL format
Extension for specialized, per-table replication between PostgreSQL instances
Replication manager for PostgreSQL
build fact tables with Postgres
pg_bulkload is a high speed data loading utility for PostgreSQL
SQL-based test/example module for WAL logical decoding
Logical Replication output plugin