select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

PostgreSQL Extension Catalogue

Explore 2387 PostgreSQL extensions from PGEXT, maintained by Pigsty.

pg_lake_spatial · Adds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. · 3.5 · Geospatial · Apache-2.0 · C · Not packagedpointcloud_postgis · integration for pointcloud LIDAR data and PostGIS geometry data · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedh3_postgis · H3 PostGIS integration · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedpgh3 · Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries · 0.3.0 · Geospatial · Apache-2.0 · C · Not packagedpghydro · Drainage network analysis core for PostgreSQL and PostGIS · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedvrprouting · Vehicle Routing Problems on the Database · 0.5.0 · Geospatial · GPL-2.0 · C++ · Not packagedplv8geo · PL/v8 geospatial functions that bundle D3, TopoJSON, JSTS, GeoTIFF and related JavaScript libraries for PostGIS workflows. · 0.0.2 · Geospatial · MIT · JavaScript · Not packagedlostgis · LostGIS spatial helper functions and types · 1.0.2 · Geospatial · BSD-3-Clause · SQL · Not packageds2 · PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy · 0.0.2 · Geospatial · MIT · Python · Not packagedast_postgis · Advanced spatial data types and spatial integrity constraints for PostGIS. · 1.1.1 · Geospatial · MIT · SQL · Not packagedpg_eviltransform · Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform · 0.0.4 · Geospatial · MIT · Rust · Packagedaddress_standardizer · Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedaddress_standardizer_data_us · Address Standardizer US dataset example · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis · PostGIS geometry and geography spatial types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_raster · PostGIS raster types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_sfcgal · PostGIS SFCGAL functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_tiger_geocoder · PostGIS tiger geocoder and reverse geocoder · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpostgis_topology · PostGIS topology spatial types and functions · 3.6.4 · Geospatial · GPL-2.0 · C · Packagedpg_landmetrics · A PostgreSQL/PostGIS extension for calculating landscape metrics. · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedpggeojson · A GeoJSON generating extension for PostGIS · 1.0 · Geospatial · Apache-2.0 · SQL · Not packagedvasavgeom · Vague geometry handler - VASA · 1.1 · Geospatial · GPL-2.0 · C · Not packagedfestival · FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices · 1.1.1 · Geospatial · GPL-3.0 · C · Not packagedpostgis_letters · convert text letters into PostGIS geometries using packaged vector fonts · 0.0.5 · Geospatial · MIT · SQL · Not packagedpg_trajectory · Define PostGIS trajectory types and spatiotemporal analysis functions in SQL and PL/pgSQL · 0.0.1 · Geospatial · Unknown · SQL · Not packagedqdgc · Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. · 0.1.0 · Geospatial · Apache-2.0 · SQL · Packagedqdgc_postgis · Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC. · 0.1.0 · Geospatial · Apache-2.0 · SQL · Packagedfrapi · In-database wrappers for French public-administration data APIs. · 0.1.2 · Geospatial · MIT · SQL · Not packagedrostgis · Experimental PostGIS-compatible spatial extension written in Rust. · 0.1.0 · Geospatial · MIT · Rust · Not packagedbrin4postgis · BRIN indexes for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedlivewire · power delivery modeling · 0.2.0 · Geospatial · Unknown · SQL · Not packagedpg_geohash_extra · Additional geohash functions for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · C · Not packagedsiguanet_quest · Application-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases. · 1.0 · Geospatial · GPL-3.0 · SQL · Not packagedfirefly · PostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. · 0.2.0 · Geospatial · GPL-3.0 · SQL · Not packagedpg_twkb · TWKB tools etc · 0.1 · Geospatial · GPL-2.0 · C · Not packagedpostgis_domains · Define reusable PostGIS geometry and geography domains constrained to valid, simple SRID 4326 values · 1.0 · Geospatial · MIT · SQL · Not packageddumppoints · C implementation of ST_DumpPoints for PostGIS geometry collections. · 1.0 · Geospatial · Public Domain · C · Not packagednfiesta_gisdata · nfi gisdata database · 3.0.7 · Geospatial · Unknown · SQL · Not packagedrtiles · Rust/PostGIS extension for serving configurable Mapbox Vector Tile layers for self-hosted interactive maps. · 0.0.0 · Geospatial · Apache-2.0 · Rust · Not packaged

38 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
postgis 3.6.4 PostGIS geometry and geography spatial types and functions GIS GPL-2.0 C 14–18 9
postgis_raster 3.6.4 PostGIS raster types and functions GIS GPL-2.0 C 14–18 9
postgis_sfcgal 3.6.4 PostGIS SFCGAL functions GIS GPL-2.0 C 14–18 9
postgis_tiger_geocoder 3.6.4 PostGIS tiger geocoder and reverse geocoder GIS GPL-2.0 C 14–18 9
postgis_topology 3.6.4 PostGIS topology spatial types and functions GIS GPL-2.0 C 14–18 9
postgis_letters 0.0.5 convert text letters into PostGIS geometries using packaged vector fonts GIS MIT SQL 10–18 5
postgis_domains 1.0 Define reusable PostGIS geometry and geography domains constrained to valid, simple SRID 4326 values GIS MIT SQL 10 1
pg_lake_spatial 3.5 Adds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. GIS Apache-2.0 C 16–18 1.6k
pointcloud_postgis 1.2.5 integration for pointcloud LIDAR data and PostGIS geometry data GIS BSD-3-Clause C 14–18 426
h3_postgis 4.5.0 H3 PostGIS integration GIS Apache-2.0 C 14–18 381
pgh3 0.3.0 Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries GIS Apache-2.0 C 10–13 85
pghydro 6.6 Drainage network analysis core for PostgreSQL and PostGIS GIS GPL-2.0 SQL 14–18 47
vrprouting 0.5.0 Vehicle Routing Problems on the Database GIS GPL-2.0 C++ 31
plv8geo 0.0.2 PL/v8 geospatial functions that bundle D3, TopoJSON, JSTS, GeoTIFF and related JavaScript libraries for PostGIS workflows. GIS MIT JavaScript 29
lostgis 1.0.2 LostGIS spatial helper functions and types GIS BSD-3-Clause SQL 10–18 26
s2 0.0.2 PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy GIS MIT Python 21
ast_postgis 1.1.1 Advanced spatial data types and spatial integrity constraints for PostGIS. GIS MIT SQL 15–17 18
pg_eviltransform 0.0.4 Coordinate transforms for BD09/GCJ02 via PostGIS ST_Transform GIS MIT Rust 14–18 12
address_standardizer 3.6.4 Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. GIS GPL-2.0 C 14–18 9
address_standardizer_data_us 3.6.4 Address Standardizer US dataset example GIS GPL-2.0 C 14–18 9
pg_landmetrics 0.0.1 A PostgreSQL/PostGIS extension for calculating landscape metrics. GIS GPL-3.0 SQL 7
pggeojson 1.0 A GeoJSON generating extension for PostGIS GIS Apache-2.0 SQL 7
vasavgeom 1.1 Vague geometry handler - VASA GIS GPL-2.0 C 7
festival 1.1.1 FESTIval is a PostgreSQL extension for conducting performance evaluations of spatial indices GIS GPL-3.0 C 6
pg_trajectory 0.0.1 Define PostGIS trajectory types and spatiotemporal analysis functions in SQL and PL/pgSQL GIS SQL 4
qdgc 0.1.0 Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. GIS Apache-2.0 SQL 14–18 4
qdgc_postgis 0.1.0 Add PostGIS geometry and geography bindings plus area-to-cell fills for QDGC. GIS Apache-2.0 SQL 14–18 4
frapi 0.1.2 In-database wrappers for French public-administration data APIs. GIS MIT SQL 3
rostgis 0.1.0 Experimental PostGIS-compatible spatial extension written in Rust. GIS MIT Rust 13–17 3
brin4postgis 0.0.1 BRIN indexes for PostGIS GIS GPL-3.0 SQL 10–18 2
livewire 0.2.0 power delivery modeling GIS SQL 10 2
pg_geohash_extra 0.0.1 Additional geohash functions for PostGIS GIS GPL-3.0 C 2
siguanet_quest 1.0 Application-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases. GIS GPL-3.0 SQL 10–18 2
firefly 0.2.0 PostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. GIS GPL-3.0 SQL 1
pg_twkb 0.1 TWKB tools etc GIS GPL-2.0 C 1
dumppoints 1.0 C implementation of ST_DumpPoints for PostGIS geometry collections. GIS Public Domain C
nfiesta_gisdata 3.0.7 nfi gisdata database GIS SQL
rtiles 0.0.0 Rust/PostGIS extension for serving configurable Mapbox Vector Tile layers for self-hosted interactive maps. GIS Apache-2.0 Rust 16