By Category
The 576 packaged PostgreSQL extensions (in 471 package families) are organized into 16 categories.
TIME
TimescaleDB, Versioning & Temporal Table, Crontab, Async & Background Job Scheduler, …
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 1000 | timescaledb | 2.29.1 | Enables scalable inserts and complex queries for time-series data |
| 1010 | timescaledb_toolkit | 1.23.0 | Library of analytical hyperfunctions, time-series pipelining, and other SQL utilities |
| 1020 | timeseries / pg_timeseries | 0.2.1 | Convenience API for time series stack |
| 1030 | periods | 1.2.3 | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| 1040 | temporal_tables | 1.2.2 | temporal tables |
| 1050 | emaj | 5.0.0 | Enables fine-grained write logging and time travel on subsets of the database. |
| 1060 | table_version | 1.11.1 | PostgreSQL table versioning extension |
| 1070 | pg_cron | 1.6.7 | Job scheduler for PostgreSQL |
| 1080 | pg_task | 2.1.29 | execute any sql command at any specific time at background |
| 1090 | pg_later | 0.4.0 | Run queries now and get results later |
| 1100 | pg_dispatch | 0.1.5 | Asynchronous SQL dispatcher built on pg_cron |
| 1110 | pg_background | 2.0.2 | Run SQL queries in the background |
| 1120 | pg_when | 0.1.10 | Natural language time parsing for PostgreSQL |
| 1130 | pg_stl | 1.0.0 | Time series analysis functions for PostgreSQL |
| 1140 | cron_utils | 0.1.0 | Parse cron expressions and compute previous or next trigger times |
GIS
GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 1500 | postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions |
| 1501 | postgis_topology / postgis | 3.6.4 | PostGIS topology spatial types and functions |
| 1502 | postgis_raster / postgis | 3.6.4 | PostGIS raster types and functions |
| 1503 | postgis_sfcgal / postgis | 3.6.4 | PostGIS SFCGAL functions |
| 1504 | postgis_tiger_geocoder / postgis | 3.6.4 | PostGIS tiger geocoder and reverse geocoder |
| 1505 | address_standardizer / postgis | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. |
| 1506 | address_standardizer_data_us / postgis | 3.6.4 | Address Standardizer US dataset example |
| 1510 | pgrouting | 4.0.1 | pgRouting Extension |
| 1520 | pointcloud | 1.2.5 | data type for lidar point clouds |
| 1521 | pointcloud_postgis / pointcloud | 1.2.5 | integration for pointcloud LIDAR data and PostGIS geometry data |
| 1530 | h3 / pg_h3 | 4.2.3 | H3 bindings for PostgreSQL |
| 1531 | h3_postgis / pg_h3 | 4.2.3 | H3 PostGIS integration |
| 1540 | q3c | 2.0.5 | q3c sky indexing plugin |
| 1550 | ogr_fdw | 1.1.9 | foreign-data wrapper for GIS data access |
| 1560 | geoip | 0.3.0 | IP-based geolocation query |
| 1570 | pg_polyline | 0.0.1 | Fast Google Encoded Polyline encoding & decoding for postgres |
| 1580 | pg_eviltransform | 0.0.4 | Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform |
| 1590 | pg_geohash | 1.0 | Handle geohash based functionality for spatial coordinates |
| 1600 | pghydro | 6.6 | Drainage network analysis core for PostgreSQL and PostGIS |
| 1601 | pgh_raster / pghydro | 6.6 | Raster hydrology extension for PgHydro |
| 1602 | pgh_hgm / pghydro | 2.2.6 | Hydrogeomorphological analysis extension for PgHydro |
| 1603 | pgh_output / pghydro | 6.6 | Output and reporting objects for PgHydro |
| 1604 | pgh_output_en_au / pghydro | 6.6 | Australian English output pack for PgHydro |
| 1605 | pgh_output_pt_br / pghydro | 6.6 | Brazilian Portuguese output pack for PgHydro |
| 1606 | pgh_consistency / pghydro | 6.6 | Pfafstetter consistency checks for PgHydro |
| 1650 | mobilitydb | 1.3.0 | MobilityDB geospatial trajectory data management & analysis platform |
| 1651 | mobilitydb_datagen / mobilitydb | 1.3.0 | MobilityDB random data generator functions |
| 1680 | tzf / pg_tzf | 0.3.0 | Fast lookup timezone name by GPS coordinates |
| 1690 | earthdistance | 1.2 | calculate great-circle distances on the surface of the Earth |
| 1700 | qdgc | 0.1.0 | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
| 1710 | qdgc_postgis / qdgc | 0.1.0 | Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC. |
RAG
Vector Database with Ivfflat, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 1800 | vector / pgvector | 0.8.6 | vector data type and ivfflat and hnsw access methods |
| 1810 | vchord | 1.1.1 | Vector database plugin for Postgres, written in Rust |
| 1820 | vectorscale / pgvectorscale | 0.9.0 | Advanced indexing for vector data with DiskANN |
| 1830 | vectorize / pg_vectorize | 0.26.2 | The simplest way to do vector search on Postgres |
| 1840 | pg_similarity | 1.0 | support similarity queries |
| 1845 | pg_rrf | 0.0.3 | Reciprocal rank fusion functions for hybrid search |
| 1850 | smlar | 1.0 | Effective similarity search |
| 1860 | pg_summarize | 0.0.1 | Text Summarization using LLMs. Built using pgrx |
| 1870 | pg_tiktoken | 0.0.1 | tiktoken tokenizer for use with OpenAI models in postgres |
| 1880 | pg_tiktoken_c | 1.1 | Fast tiktoken BPE tokenizer for PostgreSQL implemented in C |
| 1930 | pg4ml | 2.0 | Machine learning framework for PostgreSQL |
| 1940 | pgml | 2.10.0 | Run AL/ML workloads with SQL interface |
| 1950 | pgmnemo | 0.16.1 | Single-plan multimodal agent memory for PostgreSQL |
| 1960 | pgcontext | 0.2.0 | Vector, filter-aware HNSW, and hybrid retrieval over authoritative PostgreSQL tables. |
| 1970 | pgcontext_pgvector / pgcontext | 0.2.0 | Optional pgvector compatibility bridge for pgcontext HNSW indexes. |
| 1980 | pg_turbovec | 1.29.0 | TurboQuant-compressed vector type and ANN index access method for PostgreSQL. |
FTS
ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 2100 | pg_search | 0.25.2 | Full text search for PostgreSQL using BM25 |
| 2110 | pgroonga | 4.0.4 | Use Groonga as index, fast full text search platform for all languages! |
| 2111 | pgroonga_database / pgroonga | 4.0.4 | PGroonga database management module |
| 2120 | pg_bigm | 1.2 | create 2-gram (bigram) index for faster full text search. |
| 2130 | zhparser | 2.3 | a parser for full-text search of Chinese |
| 2140 | pg_bestmatch | 0.0.2 | Generate BM25 sparse vector inside PostgreSQL |
| 2150 | vchord_bm25 | 0.3.0 | A postgresql extension for bm25 ranking algorithm |
| 2160 | pg_tokenizer | 0.1.1 | Tokenizers for full-text search |
| 2170 | biscuit / pg_biscuit | 3.0.0 | IAM-LIKE pattern matching with bitmap indexing |
| 2180 | pg_textsearch | 1.2.0 | Full-text search with BM25 ranking |
| 2190 | pg_pinyin | 0.0.5 | Pinyin romanization and search helpers for PostgreSQL |
| 2200 | pg_kazsearch | 2.3.0 | Kazakh full-text search extension for PostgreSQL |
| 2210 | psql_bm25s | 0.4.13 | PostgreSQL extension for BM25-family lexical retrieval |
| 2220 | pg_fts | 0.2.0 | Full-text search with BM25 and BM25F ranking |
| 2230 | pg_cjk_parser | 0.1.0 | CJK bigram parser derived from PostgreSQL full-text search |
| 2240 | pg_jieba | 1.1.0 | Chinese full-text search parser based on cppjieba |
| 2270 | hunspell_cs_cz / hunspell | 1.0 | Czech Hunspell Dictionary |
| 2271 | hunspell_de_de / hunspell | 1.0 | German Hunspell Dictionary |
| 2272 | hunspell_en_us / hunspell | 1.0 | en_US Hunspell Dictionary |
| 2273 | hunspell_fr / hunspell | 1.0 | French Hunspell Dictionary |
| 2274 | hunspell_ne_np / hunspell | 1.0 | Nepali Hunspell Dictionary |
| 2275 | hunspell_nl_nl / hunspell | 1.0 | Dutch Hunspell Dictionary |
| 2276 | hunspell_nn_no / hunspell | 1.0 | Norwegian (norsk) Hunspell Dictionary |
| 2277 | hunspell_pt_pt / hunspell | 1.0 | Portuguese Hunspell Dictionary |
| 2278 | hunspell_ru_ru / hunspell | 1.0 | Russian Hunspell Dictionary |
| 2279 | hunspell_ru_ru_aot / hunspell | 1.0 | Russian Hunspell Dictionary (from AOT.ru group) |
| 2380 | fuzzystrmatch | 1.2 | determine similarities and distance between strings |
| 2390 | pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams |
OLAP
DuckDB Integration with FDW & PG Lakehouse, Access Parquet from File/S3, Sharding with Citus/Partman/PlProxy, …
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 2400 | citus | 14.2.0 | Distributed PostgreSQL as an extension |
| 2401 | citus_columnar / citus | 14.2.0 | Citus columnar storage engine |
| 2410 | columnar / hydra | 1.1.2 | Hydra Columnar extension |
| 2430 | pg_duckdb | 1.1.1 | DuckDB Embedded in Postgres |
| 2440 | pg_mooncake | 0.2.0 | Columnstore Table in Postgres |
| 2450 | storage_engine | 2.4.0 | colcompress and rowcompress Table Access Methods with vectorized execution |
| 2460 | pg_clickhouse | 0.10.0 | Interfaces to query ClickHouse databases from PostgreSQL |
| 2470 | duckdb_fdw | 1.4.3 | DuckDB Foreign Data Wrapper |
| 2480 | pg_parquet | 0.5.1 | copy data between Postgres and Parquet |
| 2490 | pg_ducklake | 1.0.0 | DuckLake lakehouse extension for PostgreSQL, backed by DuckDB and Parquet |
| 2500 | pg_fkpart | 1.7.0 | Table partitioning by foreign key utility |
| 2510 | pg_partman | 5.5.0 | Extension to manage partitioned tables by time or ID |
| 2520 | plproxy | 2.12.0 | Database partitioning implemented as procedural language |
| 2530 | pg_strom | 6.1 | PG-Strom - big-data processing acceleration using GPU and NVME |
| 2540 | pg_orca | 1.0.0 | ORCA query optimizer as a PostgreSQL extension |
| 2550 | pg_sorted_heap | 0.14.0 | Sorted heap table AM with zone map scan pruning and built-in vector search |
| 2560 | pg_lake | 3.4 | Data lake extension by Snowflake |
| 2561 | pg_extension_base / pg_lake | 3.4 | Extension development kit by Snowflake |
| 2562 | pg_extension_updater / pg_lake | 3.4 | Automatic extension updater |
| 2563 | pg_map / pg_lake | 3.4 | Map type for PostgreSQL, bundled as a required pg_lake component. |
| 2564 | pg_lake_engine / pg_lake | 3.4 | Query engine for data lake queries |
| 2565 | pg_lake_iceberg / pg_lake | 3.4 | Iceberg implementation in Postgres |
| 2566 | pg_lake_table / pg_lake | 3.4 | Data lake tables and Iceberg tables |
| 2567 | pg_lake_copy / pg_lake | 3.4 | Copy to/from data lake files |
| 2590 | tablefunc | 1.0 | functions that manipulate whole tables, including crosstab |
FEAT
OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 2600 | age | 1.8.0 | AGE graph database extension |
| 2610 | pg_liquid | 0.1.7 | Liquid-inspired Datalog graph query extension for PostgreSQL |
| 2620 | onesparse / one_sparse | 1.0.0 | Sparse linear algebra and graph extension for PostgreSQL 18 |
| 2630 | graph / pggraph | 1.0.0 | Graph database capabilities for PostgreSQL |
| 2640 | pgrdf | 0.6.20 | RDF, SPARQL, SHACL, and OWL reasoning for PostgreSQL |
| 2650 | pgq | 3.5.1 | Generic queue for PostgreSQL |
| 2660 | pgmq | 1.12.0 | A lightweight message queue. Like AWS SQS and RSMQ but on Postgres. |
| 2670 | pgmb | 1.0.0 | A simple PostgreSQL Message Broker system |
| 2680 | ulak | 0.0.2 | Transactional Outbox extension for PostgreSQL with reliable asynchronous delivery |
| 2690 | fsm_core | 1.1.0 | Finite state machine toolkit for PostgreSQL |
| 2700 | hll | 2.21 | type for storing hyperloglog data |
| 2710 | rum | 1.3.15 | RUM index access method |
| 2720 | pg_ai_query | 0.1.1 | AI-powered SQL query generation for PostgreSQL |
| 2730 | pg_ttl_index | 3.0.0 | Automatic data expiration with TTL indexes |
| 2740 | pg_graphql | 1.6.1 | Add in-database GraphQL support |
| 2750 | pg_jsonschema | 0.3.4 | PostgreSQL extension providing JSON Schema validation |
| 2760 | jsonschema | 0.1.9 | JSON Schema validation functions for PostgreSQL |
| 2770 | jsquery | 1.2 | data type for jsonb inspection |
| 2780 | pg_hint_plan | 1.8.0 | Give PostgreSQL ability to manually force some decisions in execution plans. |
| 2790 | hypopg | 1.4.3 | Hypothetical indexes for PostgreSQL |
| 2800 | index_advisor | 0.2.0 | Query index advisor |
| 2810 | plan_filter / pg_plan_filter | 0.0.1 | filter statements by their execution plans. |
| 2820 | pg_variables | 1.2.5 | Session-scoped variables with scalar, array, and record types |
| 2830 | imgsmlr | 1.0 | Image similarity with haar |
| 2840 | pg_ivm | 1.15 | incremental view maintenance on PostgreSQL |
| 2850 | pg_incremental | 1.5.0 | Incremental Processing by Crunchy Data |
| 2860 | pg_trickle | 0.81.0 | Streaming tables and differential view maintenance for PostgreSQL 18 |
| 2870 | pg_durable | 0.2.3 | Durable SQL functions for PostgreSQL |
| 2880 | pg_disorder | 0.1.0 | Perturb unordered SELECT row order to expose order-dependent tests |
| 2890 | pg_local_cache | 1.3.0 | Transaction-aware shared-memory cache for ordinary PostgreSQL primary-key reads |
| 2900 | provsql | 1.12.0 | Semiring provenance and probability management for PostgreSQL |
| 2910 | orioledb | 1.8 | OrioleDB, the next generation transactional engine |
| 2920 | pg_cardano | 1.2.0 | A suite of Cardano-related tools |
| 2930 | rdkit | 202503.6 | Cheminformatics functionality for PostgreSQL. |
| 2940 | omni / omnigres | 0.2.14 | Advanced adapter for Postgres extensions |
| 2941 | omni_auth / omnigres | 0.1.3 | Basic session management |
| 2942 | omni_aws / omnigres | 0.1.2 | Amazon Web Services APIs (S3) |
| 2943 | omni_cloudevents / omnigres | 0.1.0 | CloudEvents support |
| 2944 | omni_containers / omnigres | 0.2.0 | Docker container management |
| 2945 | omni_credentials / omnigres | 0.2.0 | Application credential management |
| 2946 | omni_csv | 0.1.1 | CSV toolkit |
| 2947 | omni_datasets | 0.1.0 | Dataset provisioning |
| 2948 | omni_email / omnigres | 0.1.0 | E-mail framework |
| 2949 | omni_http / omnigres | 0.1.0 | Basic HTTP types |
| 2950 | omni_httpc / omnigres | 0.1.10 | HTTP client |
| 2951 | omni_httpd / omnigres | 0.4.11 | HTTP server |
| 2952 | omni_id / omnigres | 0.4.3 | Identity types |
| 2953 | omni_json / omnigres | 0.1.1 | JSON toolkit |
| 2954 | omni_kube / omnigres | 0.4.2 | Kubernetes (k8s) integration |
| 2955 | omni_ledger / omnigres | 0.1.3 | Financial ledger |
| 2956 | omni_manifest / omnigres | 0.1.2 | Package installation manifests |
| 2957 | omni_mimetypes / omnigres | 0.1.0 | MIME types |
| 2958 | omni_os / omnigres | 0.1.1 | Operating system integration |
| 2959 | omni_polyfill / omnigres | 0.2.2 | Postgres API polyfills |
| 2960 | omni_python / omnigres | 0.1.1 | First-class Python support |
| 2961 | omni_regex / omnigres | 0.1.0 | PCRE-compatible regular expressions |
| 2962 | omni_rest / omnigres | 0.1.1 | REST API toolkit (with PostgREST support) |
| 2963 | omni_schema / omnigres | 0.3.0 | Advanced schema management tooling |
| 2964 | omni_seq / omnigres | 0.1.1 | Distributed integer sequences |
| 2965 | omni_service / omnigres | 0.1.0 | Service management |
| 2966 | omni_session / omnigres | 0.2.0 | Session management |
| 2967 | omni_shmem | 0.1.0 | Shared Memory Management |
| 2968 | omni_sql / omnigres | 0.5.3 | Programmatic SQL manipulation |
| 2969 | omni_sqlite / omnigres | 0.2.2 | Embedded SQLite |
| 2970 | omni_test / omnigres | 0.4.0 | Testing framework |
| 2971 | omni_txn / omnigres | 0.5.0 | Transaction management |
| 2972 | omni_types / omnigres | 0.3.6 | Advanced types |
| 2973 | omni_var / omnigres | 0.3.0 | Scoped variables |
| 2974 | omni_vfs / omnigres | 0.2.2 | Virtual File System |
| 2975 | omni_vfs_types_v1 / omnigres | 0.1.0 | Virtual File System types (v1) |
| 2976 | omni_web / omnigres | 0.3.0 | Common web stack primitives |
| 2977 | omni_worker / omnigres | 0.2.1 | Generalized worker pool |
| 2978 | omni_xml / omnigres | 0.1.2 | XML toolkit |
| 2979 | omni_yaml / omnigres | 0.1.0 | YAML toolkit |
| 2980 | pg_mentat | 1.5.7 | Datomic-compatible data model and Datalog query engine inside PostgreSQL |
| 2990 | bloom | 1.0 | bloom access method - signature file based index |
LANG
Develop, Test, Package, and Deliver Stored Procedures written in various PL/Languages: Java, Js, Lua, R, Sh, PRQL, …
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 3000 | pg_tle | 1.5.2 | Trusted Language Extensions for PostgreSQL |
| 3010 | plv8 | 3.2.4 | PL/JavaScript (v8) trusted procedural language |
| 3011 | pljs | 1.0.5 | PL/JS trusted procedural language |
| 3020 | pllua | 2.0.12 | Lua as a procedural language |
| 3021 | hstore_pllua / pllua | 2.0.12 | Hstore transform for Lua |
| 3030 | plluau / pllua | 2.0.12 | Lua as an untrusted procedural language |
| 3031 | hstore_plluau / pllua | 2.0.12 | Hstore transform for untrusted Lua |
| 3040 | plprql | 18.0.1 | Use PRQL in PostgreSQL - Pipelined Relational Query Language |
| 3050 | pldbgapi / pldebugger | 1.10 | server-side support for debugging PL/pgSQL functions |
| 3060 | plpgsql_check | 2.10.4 | Additional validation, profiling, and diagnostics for PL/pgSQL functions |
| 3070 | plprofiler | 4.2.5 | server-side support for profiling PL/pgSQL functions |
| 3080 | plsh | 1.20220917 | PL/sh procedural language |
| 3090 | pljava | 1.6.10 | PL/Java procedural language |
| 3100 | plr | 8.4.8.6 | load R interpreter and execute R script from within a database |
| 3110 | plxslt | 0.20140221 | XSLT procedural language for PostgreSQL |
| 3120 | pg_mockable | 1.1.0 | Create mockable wrappers for PostgreSQL functions in tests |
| 3130 | pgsqlmock | 1.0.1 | Mocking and faking helpers for PostgreSQL unit tests |
| 3140 | plx | 1.3.1 | Transpile multiple procedural dialects to PL/pgSQL |
| 3150 | pgwasm | 0.1.0 | Run sandboxed WebAssembly components as strongly typed PostgreSQL SQL functions. |
| 3160 | plruby | 2.5 | Embed MRI Ruby as an untrusted PostgreSQL procedural language |
| 3161 | jsonb_plruby / plruby | 1.0 | Transform between jsonb and native Ruby data for PL/Ruby |
| 3162 | hstore_plruby / plruby | 1.0 | Transform between hstore and Ruby Hashes for PL/Ruby |
| 3163 | ltree_plruby / plruby | 1.0 | Transform between ltree and Ruby Arrays for PL/Ruby |
| 3200 | pgtap | 1.3.4 | Unit testing for PostgreSQL |
| 3210 | faker | 0.5.3 | Wrapper for the Faker Python library |
| 3220 | dbt2 | 0.61.7 | OSDL-DBT-2 test kit |
| 3230 | pg_regresql | 2.0.0 | Trust pg_class statistics for planning instead of physical relation size |
| 3240 | pltcl | 1.0 | PL/Tcl procedural language |
| 3250 | pltclu / pltcl | 1.0 | PL/TclU untrusted procedural language |
| 3260 | plperl | 1.0 | PL/Perl procedural language |
| 3261 | bool_plperl / plperl | 1.0 | transform between bool and plperl |
| 3262 | hstore_plperl / plperl | 1.0 | transform between hstore and plperl |
| 3263 | jsonb_plperl / plperl | 1.0 | transform between jsonb and plperl |
| 3270 | plperlu | 1.0 | PL/PerlU untrusted procedural language |
| 3271 | bool_plperlu / plperlu | 1.0 | transform between bool and plperlu |
| 3272 | jsonb_plperlu / plperlu | 1.0 | transform between jsonb and plperlu |
| 3273 | hstore_plperlu / plperlu | 1.0 | transform between hstore and plperlu |
| 3280 | plpgsql | 1.0 | PL/pgSQL procedural language |
| 3290 | plpython3u | 1.0 | PL/Python3U untrusted procedural language |
| 3291 | jsonb_plpython3u / plpython3u | 1.0 | transform between jsonb and plpython3u |
| 3292 | ltree_plpython3u / plpython3u | 1.0 | transform between ltree and plpython3u |
| 3293 | hstore_plpython3u / plpython3u | 1.0 | transform between hstore and plpython3u |
TYPE
Dedicate New Data Types Like: prefix, semver, uint, SIUnit, RoaringBitmap, Rational, Sphere, Hash, RRule, and more…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 3500 | prefix / pg_prefix | 1.2.11 | Prefix Range module for PostgreSQL |
| 3510 | semver / pg_semver | 0.41.0 | Semantic version data type |
| 3520 | pg_text_semver | 1.2.1 | Semantic version domain and comparison operators for PostgreSQL |
| 3550 | unit / pgunit | 7.10 | SI units extension |
| 3570 | pgpdf | 0.1.0 | PDF type with meta admin & Full-Text Search |
| 3590 | pglite_fusion | 0.0.6 | Embed an SQLite database in your PostgreSQL table |
| 3610 | md5hash | 1.0.1 | type for storing 128-bit binary data inline |
| 3620 | asn1oid | 1.6 | asn1oid extension |
| 3630 | roaringbitmap / pg_roaringbitmap | 1.2.0 | support for Roaring Bitmaps |
| 3640 | pgfaceting | 0.2.0 | fast faceting queries using an inverted index |
| 3650 | pg_sphere / pgsphere | 1.5.2 | spherical objects with useful functions, operators and index support |
| 3660 | country / pg_country | 0.0.3 | Country data type, ISO 3166-1 |
| 3670 | pg_xenophile | 0.8.3 | More than the bare necessities for PostgreSQL i18n and l10n. |
| 3671 | l10n_table_dependent_extension / pg_xenophile | 0.8.3 | PostgreSQL l10n toolbox |
| 3680 | currency / pg_currency | 0.0.3 | Custom PostgreSQL currency type in 1Byte |
| 3690 | collection / pgcollection | 2.0.0 | Memory optimized data type to be used inside of plpglsql func |
| 3700 | pgmp | 1.0.6 | Multiple Precision Arithmetic extension |
| 3710 | numeral | 1.3 | numeral datatypes extension |
| 3720 | pg_rational | 0.0.3 | bigint fractions |
| 3730 | uint / pguint | 1.20250815 | unsigned integer types |
| 3740 | uint128 / pg_uint128 | 1.2.0 | Native uint128 type |
| 3750 | hashtypes | 0.1.5 | sha1, md5 and other data types for PostgreSQL |
| 3760 | postbis | 1.0 | Adds compressed DNA, RNA, amino-acid, and aligned sequence types with casts, operators, indexes, and bioinformatics functions. |
| 3770 | ip4r | 2.4.3 | IPv4/v6 and IPv4/v6 range index type for PostgreSQL |
| 3790 | uri / pg_uri | 1.20251029 | URI Data type for PostgreSQL |
| 3800 | emailaddr / pg_emailaddr | 0 | Email address type for PostgreSQL |
| 3810 | acl / pg_acl | 1.0.4 | ACL Data type |
| 3820 | debversion | 1.2.0 | Debian version number data type |
| 3850 | pg_duration | 1.0.2 | data type for representing durations |
| 3860 | pg_bikram_sambat | 0.1.0 | Bikram Sambat date type and AD/BS conversion functions |
| 3880 | pg_rrule | 0.3.0 | RRULE field type for PostgreSQL |
| 3890 | pgcalendar | 1.1.0 | Recurring calendar, schedule, and exception management for PostgreSQL |
| 3900 | timestamp9 | 1.4.0 | timestamp nanosecond resolution |
| 3910 | pgbson | 2.1.0 | BSON data type and accessor functions for PostgreSQL |
| 3920 | chkpass | 1.0 | data type for auto-encrypted passwords |
| 3930 | isn | 1.2 | data types for international product numbering standards |
| 3940 | seg | 1.4 | data type for representing line segments or floating-point intervals |
| 3950 | cube | 1.5 | data type for multidimensional cubes |
| 3960 | ltree | 1.3 | data type for hierarchical tree-like structures |
| 3970 | hstore | 1.8 | data type for storing sets of (key, value) pairs |
| 3980 | citext | 1.6 | data type for case-insensitive character strings |
| 3990 | xml2 | 1.1 | XPath querying and XSLT |
UTIL
Utilities such as send http request, perform gzip/zstd compress, send mails, Regex, ICU, encoding, docs, Encryption,…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 4010 | gzip / pg_gzip | 1.1.0 | gzip and gunzip functions. |
| 4020 | bzip / pg_bzip | 1.0.0 | Bzip compression and decompression |
| 4030 | zstd / pg_zstd | 1.1.2 | Zstandard compression algorithm implementation in PostgreSQL |
| 4070 | http / pg_http | 1.7.2 | HTTP client for PostgreSQL, allows web page retrieval inside the database. |
| 4080 | pg_net | 0.20.5 | Async HTTP Requests |
| 4090 | pg_curl | 2.4.5 | Run curl actions for data transfer in URL syntax |
| 4100 | pg_retry | 1.0.0 | Retry SQL statements on transient errors with exponential backoff |
| 4110 | pg_fsql | 1.1.0 | Recursive SQL template engine with JSONB-driven execution |
| 4120 | pg_protobuf | 1.0 | Protobuf support for PostgreSQL |
| 4130 | pgproto | 0.5.0 | Native Protobuf parsing, mutation, indexing, and JSON conversion support |
| 4140 | pglock | 1.0.0 | Lightweight distributed lock service inside PostgreSQL |
| 4150 | pgjq | 0.1.0 | Use jq in Postgres |
| 4160 | pgjwt | 0.2.0 | JSON Web Token API for Postgresql |
| 4170 | pg_smtp_client | 0.2.1 | PostgreSQL extension to send email using SMTP |
| 4180 | pg_html5_email_address | 1.2.3 | PostgreSQL email validation that is consistent with the HTML5 spec |
| 4190 | url_encode | 1.2.5 | url_encode, url_decode functions |
| 4200 | pgsql_tweaks | 1.0.5 | Some functions and views for daily usage |
| 4210 | pg_relation_sql | 0.2.2 | Generate inlinable SQL functions for navigating PostgreSQL foreign-key relations |
| 4220 | pg_extra_time | 2.1.0 | Some date time functions and operators that, |
| 4230 | pgpcre | 0.20190509 | Perl Compatible Regular Expression functions |
| 4235 | re2 | 0.4.1 | ClickHouse-compatible regex functions using RE2 |
| 4240 | icu_ext | 1.11.0 | Access ICU functions |
| 4250 | pgqr | 1.0 | QR Code generator from PostgreSQL |
| 4270 | envvar / pg_envvar | 1.0.1 | Fetch the value of an environment variable |
| 4275 | byteamagic / pg_byteamagic | 0.2.4 | Detect MIME types and file formats from PostgreSQL bytea values |
| 4280 | floatfile | 1.3.1 | Simple file storage for arrays of floats |
| 4285 | external_file | 1.2 | Access external server-side files through PostgreSQL functions |
| 4290 | pg_render | 0.1.3 | Render HTML in SQL |
| 4300 | pg_readme | 0.7.1 | Generate a Markdown README from PostgreSQL COMMENT objects |
| 4301 | pg_readme_test_extension / pg_readme | 0.7.1 | Fixture extension used to test pg_readme document generation |
| 4310 | ddl_historization | 0.2 | Historize the ddl changes inside PostgreSQL database |
| 4320 | data_historization | 1.1.0 | PLPGSQL Script to historize data in partitionned table |
| 4330 | schedoc / pg_schedoc | 0.0.1 | Cross documentation between Django and DBT projects |
| 4340 | pg_isok | 1.4.1 | Query-based data integrity management and soft alerting for PostgreSQL |
| 4350 | pg_describe | 1.0.0 | Report a query’s parameters and result columns without executing it |
| 4400 | hashlib / pg_hashlib | 1.1 | Stable hash functions for Postgres |
| 4430 | xxhash / pg_xxhash | 0.0.1 | xxhash functions for PostgreSQL |
| 4440 | shacrypt | 1.1 | Implements SHA256-CRYPT and SHA512-CRYPT password encryption schemes |
| 4450 | cryptint | 1.0.0 | Encryption functions for int and bigint values |
| 4460 | pguecc / pg_ecdsa | 1.0 | uECC bindings for Postgres |
| 4470 | sparql / pgsparql | 1.0 | Query SPARQL datasource with SQL |
FUNC
Function such as id generator, aggregations, sketches, vector functions, mathematical functions and digest functions…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 4500 | pg_idkit | 0.4.0 | multi-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) |
| 4510 | pgx_ulid | 0.2.3 | ulid type and methods |
| 4520 | pg_uuidv7 | 1.7.0 | Create UUIDv7 values in postgres |
| 4530 | pg_uuid_v8 | 1.1.0 | UUID v8 generator with embedded timestamps for PostgreSQL |
| 4540 | permuteseq | 1.2.2 | Pseudo-randomly permute sequences with a format-preserving encryption on elements |
| 4550 | pg_hashids | 1.3 | Short unique id generator for PostgreSQL, using hashids |
| 4560 | pg_slug_gen | 1.0.0 | Generate cryptographically secure timestamp-based slugs |
| 4570 | sequential_uuids | 1.0.3 | generator of sequential UUIDs |
| 4580 | typeid / pg_typeid | 0.3.0 | Allows to use TypeIDs in Postgres natively |
| 4590 | snowflake | 2.5.0 | Snowflake-style 64-bit ID generator and sequence utilities for PostgreSQL |
| 4600 | topn | 2.7.1 | type for top-n JSONB |
| 4610 | quantile | 1.1.8 | Quantile aggregation function |
| 4620 | lower_quantile | 1.0.3 | Lower quantile aggregate function |
| 4630 | count_distinct | 3.0.2 | An alternative to COUNT(DISTINCT …) aggregate, usable with HashAggregate |
| 4640 | omnisketch | 1.0.2 | data structure for on-line agg of data into approximate sketch |
| 4650 | ddsketch | 1.0.1 | Provides ddsketch aggregate function |
| 4660 | vasco | 0.1.0 | discover hidden correlations in your data with MIC |
| 4670 | xicor / pgxicor | 0.1.1 | XI Correlation Coefficient in Postgres |
| 4680 | weighted_statistics / pg_weighted_statistics | 1.0.0 | High-performance weighted statistics functions for sparse data |
| 4690 | datasketches | 1.7.0 | Approximate analytics sketches and aggregates for PostgreSQL |
| 4695 | fbsql | 0.1.0 | Closure-preserving formula-based statistical modeling in SQL |
| 4700 | tdigest | 1.4.4 | Provides tdigest aggregate function. |
| 4710 | first_last_agg | 0.1.4 | first() and last() aggregate functions |
| 4720 | extra_window_functions | 1.0 | Extra Window Functions for PostgreSQL |
| 4730 | floatvec | 1.1.1 | Math for vectors (arrays) of numbers |
| 4740 | aggs_for_vecs | 1.4.1 | Aggregate functions for array inputs |
| 4750 | aggs_for_arrays | 1.3.3 | Various functions for computing statistics on arrays of numbers |
| 4755 | argm | 1.1.1 | argmax, argmin, and anyold aggregate functions |
| 4760 | pg_csv | 1.0.2 | Flexible CSV processing for Postgres |
| 4770 | arraymath / pg_arraymath | 1.1 | Array math and operators that work element by element on the contents of arrays |
| 4780 | pg_math | 1.1.0 | GSL statistical functions for postgresql |
| 4790 | random / pg_random | 2.0.0 | random data generator |
| 4800 | base36 / pg_base36 | 1.0.0 | Integer Base36 types |
| 4810 | base62 / pg_base62 | 0.0.1 | Base62 extension for PostgreSQL |
| 4830 | pg_base58 | 0.0.1 | Base58 Encoder/Decoder Extension for PostgreSQL |
| 4840 | financial / pg_financial | 1.0.1 | Financial aggregate functions |
| 4845 | pg_accumulator | 1.1.3 | Accumulation registers for balance and turnover tracking in PostgreSQL |
| 4850 | convert / pg_convert | 0.1.0 | conversion functions for spatial, routing and other specialized uses |
| 4860 | parray_gin | 1.5.0 | GIN index operator class and partial-match operators for text arrays |
| 4880 | refint | 1.0 | functions for implementing referential integrity (obsolete) |
| 4881 | autoinc | 1.0 | functions for autoincrementing fields |
| 4882 | insert_username | 1.0 | functions for tracking who changed a table |
| 4883 | moddatetime | 1.0 | functions for tracking last modification time |
| 4890 | tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit |
| 4900 | dict_xsyn | 1.0 | text search dictionary template for extended synonym processing |
| 4910 | tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit |
| 4920 | tcn | 1.0 | Triggered change notifications |
| 4930 | uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) |
| 4940 | btree_gist | 1.7 | support for indexing common datatypes in GiST |
| 4950 | btree_gin | 1.3 | support for indexing common datatypes in GIN |
| 4960 | intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers |
| 4970 | intagg | 1.1 | integer aggregator and enumerator (obsolete) |
| 4980 | dict_int | 1.0 | text search dictionary template for integers |
| 4990 | unaccent | 1.1 | text search dictionary that removes accents |
ADMIN
Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 5010 | pg_repack | 1.5.3 | Reorganize tables in PostgreSQL databases with minimal locks |
| 5020 | pg_rewrite | 2.2 | Tool allows read write to the table during the rewriting |
| 5030 | pg_query_rewrite | 0.0.5 | Rewrite SQL statements with a PostgreSQL ProcessUtility hook |
| 5040 | pg_squeeze | 1.9.4 | A tool to remove unused space from a relation. |
| 5050 | pg_dirtyread | 2.8 | Read dead but unvacuumed rows from table |
| 5060 | pgfincore | 1.4.0 | examine and manage the os buffer cache |
| 5070 | pg_cooldown | 0.1 | remove buffered pages for specific relations |
| 5080 | ddlx / pg_ddlx | 0.30 | DDL eXtractor functions |
| 5090 | pglinter | 2.0.0 | PostgreSQL Linting and Analysis Extension |
| 5100 | prioritize / pg_prioritize | 1.0.4 | get and set the priority of PostgreSQL backends |
| 5110 | pg_checksums | 1.3 | Activate/deactivate/verify checksums in offline Postgres clusters |
| 5120 | pg_readonly | 1.0.6 | cluster database read only |
| 5130 | pgdd | 0.6.1 | Introspect pg data dictionary via standard SQL |
| 5140 | pg_permissions | 1.4.1 | view object permissions and compare them with the desired state |
| 5150 | pgautofailover | 2.2 | pg_auto_failover |
| 5160 | pg_catcheck | 1.6.0 | Diagnosing system catalog corruption |
| 5170 | pre_prepare / preprepare | 0.9 | Pre Prepare your Statement server side |
| 5180 | pg_upless | 0.0.3 | Detect Useless UPDATE |
| 5190 | pgcozy | 1.0 | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. |
| 5200 | pg_orphaned | 1.0 | Deal with orphaned files |
| 5210 | pg_crash | 1.0 | Send random signals to random processes |
| 5220 | pg_cheat_funcs | 1.0 | Provides cheat (but useful) functions |
| 5230 | fio / pg_fio | 1.0 | PostgreSQL File I/O Functions |
| 5240 | qos / pg_qos | 1.0 | QoS resource governor extension for PostgreSQL sessions and queries |
| 5250 | pg_pathcheck | 0.9.1 | Validate planner Path trees for freed or corrupt memory |
| 5260 | pgdisablelogerror | 1.0 | Disable selected SQLSTATE error codes from PostgreSQL server logging. |
| 5270 | online_advisor | 1.0 | Suggest missing indexes and extended statistics online |
| 5280 | pg_column_tetris | 0.1.0 | Enforce optimal column alignment to minimize row padding |
| 5290 | cat_tools | 0.3.0 | Tools for interfacing with the PostgreSQL catalog |
| 5810 | pg_savior | 0.1.0 | Postgres extension to save OOPS mistakes |
| 5820 | safeupdate | 1.5 | Require criteria for UPDATE and DELETE |
| 5830 | pg_strict | 1.0.5 | Prevent dangerous UPDATE and DELETE without WHERE clause |
| 5850 | pg_drop_events | 0.1.0 | logs transaction ids of drop table, drop column, drop materialized view statements |
| 5860 | table_log | 0.6.4 | record table modification logs and PITR for table/row |
| 5870 | pgelog | 1.0.2 | Extended logging via pseudo-autonomous transactions |
| 5880 | pgagent | 4.2.3 | A PostgreSQL job scheduler |
| 5890 | pg_prewarm | 1.2 | prewarm relation data |
| 5900 | pgpool_adm / pgpool | 4.7.2 | Administrative functions for pgPool |
| 5910 | pgpool_recovery / pgpool | 4.7.2 | recovery functions for pgpool-II for V4.3 |
| 5920 | pgpool_regclass / pgpool | 4.7.2 | replacement for regclass |
| 5930 | lo | 1.1 | Large Object maintenance |
| 5940 | basic_archive | - | an example of an archive module |
| 5950 | basebackup_to_shell | - | adds a custom basebackup target called shell |
| 5960 | old_snapshot | 1.0 | utilities in support of old_snapshot_threshold |
| 5970 | adminpack | 2.1 | administrative functions for PostgreSQL |
| 5980 | amcheck | 1.4 | functions for verifying relation integrity |
| 5990 | pg_surgery | 1.0 | extension to perform surgery on a damaged relation |
STAT
Observability Catalogs, Monitoring Metrics & Views, Statistics, Query Plans, WaitSampling, SlowLogs, and etc…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 6000 | pg_profile | 4.15 | PostgreSQL load profile repository and report builder |
| 6010 | pg_tracing | 0.1.3 | Distributed Tracing for PostgreSQL |
| 6020 | pg_stat_ch | 0.3.6 | Export PostgreSQL query telemetry to ClickHouse |
| 6030 | pg_stat_backtrace | 1.0.0 | Capture or log C-level stack backtraces of PostgreSQL processes |
| 6040 | pg_stat_log | 0.1 | Track cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE. |
| 6050 | pg_stat_plans | 2.1.0 | Track per-plan call counts, execution times, and example EXPLAIN texts. |
| 6060 | pgfr_record / pg_flight_recorder | 2.29.2 | Server-side PostgreSQL performance flight recorder |
| 6061 | pgfr_analyze / pg_flight_recorder | 2.29.2 | Reporting and analysis functions for pgfr_record |
| 6070 | pgmonitor | 2.2.0 | Collector-friendly metric views and background refresh worker |
| 6080 | pg_statviz | 1.1 | Capture PostgreSQL statistics snapshots for time-series analysis and visualization |
| 6210 | pg_show_plans | 2.1.8 | show query plans of all currently running SQL statements |
| 6220 | pg_stat_kcache | 2.3.2 | Kernel statistics gathering |
| 6230 | pg_stat_monitor | 2.3.2 | 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. |
| 6240 | pg_qualstats | 2.1.4 | An extension collecting statistics about quals |
| 6250 | pg_store_plans | 1.10 | track plan statistics of all SQL statements executed |
| 6260 | pg_track_settings | 2.1.2 | Track settings changes |
| 6270 | pg_track_optimizer | 0.9.2 | Track planning decisions in comparison with execution reality |
| 6280 | pg_wait_sampling | 1.1.11 | sampling based statistics of wait events |
| 6400 | pg_datasentinel | 1.0 | Observability and activity monitoring extension for PostgreSQL |
| 6410 | pgsentinel | 1.4.2 | active session history |
| 6420 | system_stats | 4.1 | EnterpriseDB system statistics for PostgreSQL |
| 6430 | meta / pg_meta | 0.4.0 | Normalized, friendlier system catalog for PostgreSQL |
| 6440 | pgnodemx | 2.0.1 | Capture node OS metrics via SQL queries |
| 6450 | pg_proctab / pgnodemx | 2.0.1 | PostgreSQL extension to access the OS process table |
| 6500 | pg_sqlog | 1.6 | Provide SQL interface to logs |
| 6510 | bgw_replstatus | 1.0.8 | Small PostgreSQL background worker to report whether a node is a replication master or standby |
| 6520 | pgmeminfo | 1.0.0 | show memory usage |
| 6530 | toastinfo | 1.7 | show details on toasted datums |
| 6540 | explain_ui / pg_explain_ui | 0.0.2 | easily jump into a visual plan UI for any SQL query |
| 6850 | pg_relusage | 0.0.1 | Log all the queries that reference a particular column |
| 6860 | pagevis | 0.1 | Visualise database pages in ascii code |
| 6870 | powa | 5.2.0 | PostgreSQL Workload Analyser-core |
| 6880 | pg_overexplain | 1.0 | Allow EXPLAIN to dump even more details |
| 6890 | pg_logicalinspect | 1.0 | Logical decoding components inspection |
| 6900 | pageinspect | 1.12 | inspect the contents of database pages at a low level |
| 6910 | pgrowlocks | 1.2 | show row-level locking information |
| 6920 | sslinfo | 1.2 | information about SSL certificates |
| 6930 | pg_buffercache | 1.5 | examine the shared buffer cache |
| 6940 | pg_walinspect | 1.1 | functions to inspect contents of PostgreSQL Write-Ahead Log |
| 6950 | pg_freespacemap | 1.2 | examine the free space map (FSM) |
| 6960 | pg_visibility | 1.2 | examine the visibility map (VM) and page-level visibility info |
| 6970 | pgstattuple | 1.5 | show tuple-level statistics |
| 6980 | auto_explain | - | Provides a means for logging execution plans of slow statements automatically |
| 6990 | pg_stat_statements | 1.11 | track planning and execution statistics of all SQL statements executed |
SEC
Auditing Logs, Enforce Passwords, Keep Secrets, TDE, SM Algorithm, Login Hooks, Log Errors, Extension White List, …
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 7000 | passwordcheck_cracklib | 3.1.0 | Strengthen PostgreSQL user password checks with cracklib |
| 7010 | supautils | 3.2.1 | Extension that secures a cluster on a cloud environment |
| 7020 | pgsodium | 3.1.11 | Postgres extension for libsodium functions |
| 7030 | column_encrypt | 4.0 | Transparent column-level encryption with encrypted_text and encrypted_bytea types |
| 7040 | passwordpolicy | 2.0.5 | Dynamically configurable PostgreSQL password complexity checks. |
| 7050 | supabase_vault / pg_vault | 0.3.1 | Supabase Vault Extension |
| 7060 | pg_session_jwt | 0.5.0 | Manage authentication sessions using JWTs |
| 7070 | anon / pg_anon | 3.1.3 | PostgreSQL Anonymizer (anon) extension |
| 7080 | pgsmcrypto | 0.1.1 | PostgreSQL SM Algorithm Extension |
| 7090 | pg_enigma | 0.5.0 | Encrypted postgres data type |
| 7100 | pgaudit | 18.0 | provides auditing functionality |
| 7110 | pgauditlogtofile | 1.8.5 | pgAudit addon to redirect audit log to an independent file |
| 7120 | pg_roast | 1.0 | Opinionated PostgreSQL database auditor |
| 7130 | pg_auditor | 0.2 | Audit data changes and provide flashback ability |
| 7140 | logerrors | 2.1.5 | Function for collecting statistics about messages in logfile |
| 7150 | pg_auth_mon | 3.0 | monitor connection attempts per user |
| 7160 | pg_jobmon | 1.4.1 | Extension for logging and monitoring functions in PostgreSQL |
| 7170 | pg_oidc_validator | 1.1.0 | OAuth and OIDC token validator for PostgreSQL 18 |
| 7180 | oidc_validator / pg_oidc_validator_rust | 0.1.0 | PostgreSQL 18 OIDC bearer-token validator plugin written in Rust |
| 7190 | pgmemento | 0.7.4 | Transaction-based audit trail with schema versioning |
| 7310 | credcheck | 5.0 | credcheck - postgresql plain text credential checker |
| 7320 | pgcryptokey | 0.85 | cryptographic key management |
| 7330 | pg_pwhash | 1.0 | Advanced password hashing methods for PostgreSQL |
| 7360 | login_hook | 1.7 | login_hook - hook to execute login_hook.login() at login time |
| 7370 | set_user | 4.2.0 | similar to SET ROLE but with added logging |
| 7380 | pg_snakeoil | 1.4 | The PostgreSQL Antivirus |
| 7390 | pgextwlist | 1.20 | PostgreSQL Extension Whitelisting |
| 7400 | pg_command_fw | 0.1.0 | DDL and utility command firewall for PostgreSQL |
| 7410 | sslutils | 1.4 | A Postgres extension for managing SSL certificates through SQL |
| 7420 | noset / pg_noset | 0.3.0 | Module for blocking SET variables for non-super users. |
| 7430 | block_copy_command | 0.1.5 | Block COPY commands via a configurable ProcessUtility hook |
| 7440 | pg_policy | 0.1.0 | Agentic policy language for PostgreSQL with guardrails, guidance, and session-aware controls |
| 7450 | pg_kpart | 1.0 | Reject full partition scans that omit the partition key |
| 7500 | pg_tde | 2.2.1 | Percona pg_tde access method |
| 7510 | pg_vault_tde | 1.7.0 | Transparent Data Encryption for PostgreSQL through custom table and index access methods |
| 7960 | sepgsql | - | label-based mandatory access control (MAC) based on SELinux security policy. |
| 7970 | auth_delay | - | pause briefly before reporting authentication failure |
| 7980 | pgcrypto | 1.3 | cryptographic functions |
| 7990 | passwordcheck | - | checks user passwords and reject weak password |
FDW
Wrappers & Multicorn for FDW Development, Access other DBMS: MySQL, Mongo, SQLite, MSSQL, Oracle, HDFS, DB2,…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 8500 | wrappers | 0.6.2 | Foreign data wrappers developed by Supabase |
| 8510 | multicorn | 3.2 | Fetch foreign data in Python in your PostgreSQL server. |
| 8520 | odbc_fdw | 0.5.2 | Foreign data wrapper for accessing remote databases using ODBC |
| 8530 | jdbc_fdw | 1.2 | foreign-data wrapper for remote servers available over JDBC |
| 8540 | pgspider_ext | 1.3.0 | foreign-data wrapper for remote PGSpider servers |
| 8600 | mysql_fdw | 2.9.3 | Foreign data wrapper for querying a MySQL server |
| 8610 | oracle_fdw | 2.9.0 | foreign data wrapper for Oracle access |
| 8620 | tds_fdw | 2.0.5 | Foreign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) |
| 8630 | db2_fdw | 18.2.0 | foreign data wrapper for DB2 access |
| 8640 | sqlite_fdw | 2.5.0 | SQLite Foreign Data Wrapper |
| 8650 | pgbouncer_fdw | 1.4.0 | Extension for querying PgBouncer stats from normal SQL views & running pgbouncer commands from normal SQL functions |
| 8660 | etcd_fdw | 0.0.1 | Foreign data wrapper for etcd |
| 8670 | informix_fdw | 0.6.3 | Foreign data wrapper for Informix access |
| 8680 | nominatim_fdw | 2.1.0 | Nominatim Foreign Data Wrapper for PostgreSQL |
| 8700 | mongo_fdw | 5.5.3 | foreign data wrapper for MongoDB access |
| 8710 | redis_fdw | 1.0 | Foreign data wrapper for querying a Redis server |
| 8720 | redis / pg_redis_pubsub | 0.0.1 | Send redis pub/sub messages to Redis from PostgreSQL Directly |
| 8730 | kafka_fdw | 0.0.3 | kafka Foreign Data Wrapper for CSV formatted messages |
| 8740 | hdfs_fdw | 2.0.5 | foreign-data wrapper for remote hdfs servers |
| 8750 | firebird_fdw | 1.4.2 | Foreign data wrapper for Firebird |
| 8760 | rdf_fdw | 2.7.0 | Foreign data wrapper for RDF triplestores over SPARQL endpoints |
| 8800 | aws_s3 | 0.0.1 | aws_s3 postgres extension to import/export data from/to s3 |
| 8810 | log_fdw | 1.4 | foreign-data wrapper for Postgres log file access |
| 8970 | dblink | 1.2 | connect to other PostgreSQL databases from within a database |
| 8980 | file_fdw | 1.0 | foreign-data wrapper for flat file access |
| 8990 | postgres_fdw | 1.1 | foreign-data wrapper for remote PostgreSQL servers |
SIM
Protocol Simulation & heterogeneous DBMS Compatibility: Oracle, MSSQL, DB2, MySQL, Memcached, and Babelfish!
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 9000 | documentdb | 0.114 | API surface for DocumentDB for PostgreSQL |
| 9010 | documentdb_core / documentdb | 0.114 | Core API surface for DocumentDB on PostgreSQL |
| 9020 | documentdb_distributed / documentdb | 0.114 | Multi-Node API surface for DocumentDB |
| 9030 | documentdb_extended_rum / documentdb | 0.114 | DocumentDB Extended RUM index access method |
| 9090 | pg_projection | 1.0.0 | MongoDB-like read projections for JSONB in PostgreSQL |
| 9100 | orafce | 4.16.7 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |
| 9110 | pgtt | 4.6 | Extension to add Global Temporary Tables feature to PostgreSQL |
| 9120 | session_variable | 3.4 | Registration and manipulation of session variables and constants |
| 9130 | pg_statement_rollback | 1.6 | Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
| 9140 | ivorysql_ora / ivorysql | 1.0 | Oracle Compatible extension on Postgres Database |
| 9150 | ora_btree_gin / ivorysql | 1.0 | Support for indexing oracle datatypes in GIN |
| 9160 | ora_btree_gist / ivorysql | 1.0 | Support for oracle indexing common datatypes in GiST |
| 9170 | pg_get_functiondef / ivorysql | 1.0 | Get function’s definition |
| 9180 | plisql / ivorysql | 1.0 | PL/iSQL procedural language |
| 9190 | gb18030_2022 / ivorysql | 1.0 | Support GB18030-2022 and UTF-8 conversion |
| 9200 | db2fce | 0.0.17 | DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL. |
| 9210 | plpgsql_wrap | 1.0 | Oracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source. |
| 9240 | pg_dbms_metadata | 1.0.0 | Extension to add Oracle DBMS_METADATA compatibility to PostgreSQL |
| 9250 | pg_dbms_lock | 2.0 | Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL |
| 9260 | pg_dbms_job | 2.0 | Extension to add Oracle DBMS_JOB full compatibility to PostgreSQL |
| 9270 | pg_dbms_errlog | 2.4 | Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table. |
| 9290 | pg_utl_smtp | 1.0.0 | Oracle UTL_SMTP compatibility extension for PostgreSQL |
| 9300 | babelfishpg_common / babelfish | 5.4.0 | SQL Server Transact SQL Datatype Support |
| 9310 | babelfishpg_tsql / babelfish | 5.4.0 | SQL Server Transact SQL compatibility |
| 9320 | babelfishpg_tds / babelfish | 1.0.0 | SQL Server TDS protocol extension |
| 9330 | babelfishpg_money / babelfish | 1.1.0 | SQL Server Money Data Type |
| 9410 | pgmemcache | 2.3.0 | memcached interface |
| 9420 | aux_mysql / openhalo | 1.5 | MySQL Supplementary Extension |
ETL
Logical Replication, Decoding, CDC in protobuf/JSON/Mongo format, Copy & Load & Compare Postgres Databases,…
| ID | Extension / Package | Version | Description |
|---|---|---|---|
| 9500 | pglogical | 2.4.8 | PostgreSQL Logical Replication |
| 9501 | pglogical_origin / pglogical | 2.4.7 | Dummy extension for compatibility when upgrading from Postgres 9.4 |
| 9510 | pglogical_ticker | 1.4.1 | Have an accurate view on pglogical replication delay |
| 9520 | pgl_ddl_deploy | 2.2.1 | automated ddl deployment using pglogical |
| 9530 | logical_ddl | 0.1.0 | Replicate supported DDL changes over PostgreSQL logical replication |
| 9540 | pg_failover_slots | 1.2.1 | PG Failover Slots extension |
| 9550 | db_migrator | 1.0.0 | Tools to migrate other databases to PostgreSQL |
| 9560 | pgactive | 2.1.7 | Active-Active Replication Extension for PostgreSQL |
| 9570 | spock | 5.0.10 | Multi-master logical replication extension for PostgreSQL |
| 9580 | lolor | 1.2.2 | Logical-replication-friendly replacement for PostgreSQL large objects |
| 9590 | pgclone | 4.4.2 | Clone PostgreSQL databases, schemas, tables, and functions across environments |
| 9620 | pgmqtt | 0.4.1 | CDC-to-MQTT broker for PostgreSQL |
| 9630 | wal2json | 2.6 | Changing data capture in JSON format |
| 9640 | wal2mongo | 1.0.7 | PostgreSQL logical decoding output plugin for MongoDB |
| 9650 | decoderbufs | 3.6.0 | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
| 9660 | decoder_raw | 1.0 | Output plugin for logical replication in Raw SQL format |
| 9700 | mimeo | 1.5.1 | Extension for specialized, per-table replication between PostgreSQL instances |
| 9710 | repmgr | 5.5.0 | Replication manager for PostgreSQL |
| 9820 | pg_fact_loader | 2.0.1 | build fact tables with Postgres |
| 9830 | pg_bulkload | 3.1.23 | pg_bulkload is a high speed data loading utility for PostgreSQL |
| 9970 | test_decoding | - | SQL-based test/example module for WAL logical decoding |
| 9980 | pgoutput | - | Logical Replication output plugin |