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 packagedmobilitydb · MobilityDB geospatial trajectory data management & analysis platform · 1.3.0 · Geospatial · PostgreSQL · C · Packagedpointcloud · data type for lidar point clouds · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedpointcloud_postgis · integration for pointcloud LIDAR data and PostGIS geometry data · 1.2.5 · Geospatial · BSD-3-Clause · C · Packagedh3 · H3 bindings for PostgreSQL · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedh3_postgis · H3 PostGIS integration · 4.5.0 · Geospatial · Apache-2.0 · C · Packagedogr_fdw · foreign-data wrapper for GIS data access · 1.1.9 · Geospatial · MIT · C · Packagedpostal · PostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components. · 1.0 · Geospatial · MIT · C · Not packagedq3c · q3c sky indexing plugin · 2.0.5 · Geospatial · GPL-2.0 · C · Packagedpgh3 · Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries · 0.3.0 · Geospatial · Apache-2.0 · C · Not packagedpgs2 · Postgres extension for S2 spherical geometry · 0.0.1 · Geospatial · Apache-2.0 · C · Not packagedpg_healpix · Provides PostgreSQL functions that convert sky coordinates to and from HEALPix nested and ring pixel identifiers. · 1.0 · Geospatial · GPL-2.0 · C · Not packagedzcurve · Two- and three-dimensional Z-order bit interleaving plus direct range lookup over numeric B-tree indexes. · 1.3 · Geospatial · Unknown · C · Not packagedpg_geohash · Handle geohash based functionality for spatial coordinates · 1.0 · Geospatial · MIT · C · 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_tileless · Tools for packaging twkb in sqlite for tileless · 0.1 · Geospatial · GPL-2.0 · C · 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 packagedgeohash_extra · Additional geohash functions · 0.0.1 · Geospatial · Unknown · C · Not packagedhexgrid · Configurable hex grid on abstract surface · 1.0.3 · Geospatial · BSD-3-Clause · C · Not packagedcoordconv · Convert between IAU 1958 Galactic coordinates and J2000 FK5 equatorial coordinates · 1.0.0 · Geospatial · GPL-2.0 · C · Not packagedpg_geohash_extra · Additional geohash functions for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · C · Not packagedrtosm · Real-time simplification of spatial objects in an OpenStreetMap API database. · 0.1 · Geospatial · GPL-2.0 · C · Not packagedgbuilder · Additional geometry builders · 1.0 · Geospatial · Unknown · C · Not packagedpg_twkb · TWKB tools etc · 0.1 · Geospatial · GPL-2.0 · C · Not packagedtriangle_array · Prototype PostgreSQL representation of triangulated irregular networks using compact point and triangle arrays. · 0.1 · Geospatial · Unknown · C · Not packagedastrocat · PostgreSQL extension for indexing astronomical catalogues with spherical point and circle types, GiST indexing, radial queries, and k-nearest-neighbor ordering. · 1.0 · Geospatial · Unknown · C · Not packageddumppoints · C implementation of ST_DumpPoints for PostGIS geometry collections. · 1.0 · Geospatial · Public Domain · C · Not packagedearthdistance · calculate great-circle distances on the surface of the Earth · 1.2 · Geospatial · PostgreSQL · C · Packagedganos_address_standardizer · A placename standardization extension based on the PAGC standard. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry · Provides computing and analysis features for spatial geometry types. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry_pyramid · Builds sparse vector tile pyramids for fast rendering of large 2D geometry datasets. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry_sfcgal · Provides extension features for the spatial geometry SFCGAL plugin. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geometry_topology · Ganos geometry topology spatial types and functions extension for PostgreSQL. · 7.0 · Geospatial · Unknown · C · Not packagedganos_geomgrid · Provides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems. · 7.0 · Geospatial · Unknown · C · Not packagedganos_networking · Road and traffic network analysis with cost-based shortest, fastest, and optimal path algorithms. · 7.0 · Geospatial · Unknown · C · Not packagedganos_pointcloud · Provides storage, computing, and analysis features for point clouds. · 7.0 · Geospatial · Unknown · C · Not packagedganos_pointcloud_geometry · Integrates GanosBase PointCloud types with geometry for spatial analysis. · 7.0 · Geospatial · Unknown · C · Not packagedganos_raster · Provides storage, computing, and analysis features for spatial raster data. · 7.0 · Geospatial · Unknown · C · Not packagedganos_tiger_geocoder · Ganos tiger geocoder and reverse geocoder with support for USCB TIGER data. · 7.0 · Geospatial · Unknown · C · Not packagedganos_trajectory · Models, queries, and analyzes moving-object trajectories across space and time. · 7.0 · Geospatial · Unknown · C · Not packagedgis_objects · Postgres extension for Point, Polygon, and Point-in-Polygon operations in C · 1.0 · Geospatial · Unknown · C · Not packagedhyperspace · Four-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. · 1.0 · Geospatial · Unknown · C · Not packagedipinfo · IP geolocation lookup functions backed by the ipinfo.io HTTP service. · 1.0.1 · Geospatial · Apache-2.0 · C · Not packagedpgr_dmmsy · DMMSY deterministic directed single-source shortest path algorithm for pgRouting · 0.1.0 · Geospatial · Unknown · C · Not packagedsgp4 · C extension that propagates satellite TLEs with SGP4 and returns WGS84 position as WKT. · 0.1 · Geospatial · MIT · C · Not packaged

52 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
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
mobilitydb 1.3.0 MobilityDB geospatial trajectory data management & analysis platform GIS PostgreSQL C 14–18 624
pointcloud 1.2.5 data type for lidar point clouds GIS BSD-3-Clause C 14–18 426
pointcloud_postgis 1.2.5 integration for pointcloud LIDAR data and PostGIS geometry data GIS BSD-3-Clause C 14–18 426
h3 4.5.0 H3 bindings for PostgreSQL GIS Apache-2.0 C 14–18 381
h3_postgis 4.5.0 H3 PostGIS integration GIS Apache-2.0 C 14–18 381
ogr_fdw 1.1.9 foreign-data wrapper for GIS data access GIS MIT C 14–18 264
postal 1.0 PostgreSQL bindings for libpostal that normalize free-form addresses and parse them into labeled components. GIS MIT C 10–18 146
q3c 2.0.5 q3c sky indexing plugin GIS GPL-2.0 C 14–18 90
pgh3 0.3.0 Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries GIS Apache-2.0 C 10–13 85
pgs2 0.0.1 Postgres extension for S2 spherical geometry GIS Apache-2.0 C 19
pg_healpix 1.0 Provides PostgreSQL functions that convert sky coordinates to and from HEALPix nested and ring pixel identifiers. GIS GPL-2.0 C 10–13 18
zcurve 1.3 Two- and three-dimensional Z-order bit interleaving plus direct range lookup over numeric B-tree indexes. GIS C 18
pg_geohash 1.0 Handle geohash based functionality for spatial coordinates GIS MIT C 14–18 17
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
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
pg_tileless 0.1 Tools for packaging twkb in sqlite for tileless GIS GPL-2.0 C 8
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
geohash_extra 0.0.1 Additional geohash functions GIS C 4
hexgrid 1.0.3 Configurable hex grid on abstract surface GIS BSD-3-Clause C 4
coordconv 1.0.0 Convert between IAU 1958 Galactic coordinates and J2000 FK5 equatorial coordinates GIS GPL-2.0 C 3
pg_geohash_extra 0.0.1 Additional geohash functions for PostGIS GIS GPL-3.0 C 2
rtosm 0.1 Real-time simplification of spatial objects in an OpenStreetMap API database. GIS GPL-2.0 C 2
gbuilder 1.0 Additional geometry builders GIS C 10–18 1
pg_twkb 0.1 TWKB tools etc GIS GPL-2.0 C 1
triangle_array 0.1 Prototype PostgreSQL representation of triangulated irregular networks using compact point and triangle arrays. GIS C 1
astrocat 1.0 PostgreSQL extension for indexing astronomical catalogues with spherical point and circle types, GiST indexing, radial queries, and k-nearest-neighbor ordering. GIS C
dumppoints 1.0 C implementation of ST_DumpPoints for PostGIS geometry collections. GIS Public Domain C
earthdistance 1.2 calculate great-circle distances on the surface of the Earth GIS PostgreSQL C 14–18
ganos_address_standardizer 7.0 A placename standardization extension based on the PAGC standard. GIS C 10–17
ganos_geometry 7.0 Provides computing and analysis features for spatial geometry types. GIS C 10–17
ganos_geometry_pyramid 7.0 Builds sparse vector tile pyramids for fast rendering of large 2D geometry datasets. GIS C 10–17
ganos_geometry_sfcgal 7.0 Provides extension features for the spatial geometry SFCGAL plugin. GIS C 10–17
ganos_geometry_topology 7.0 Ganos geometry topology spatial types and functions extension for PostgreSQL. GIS C 10–17
ganos_geomgrid 7.0 Provides grid partitioning, encoding, indexing, and analysis capabilities for H3, GeoSOT, and other grid systems. GIS C 10–17
ganos_networking 7.0 Road and traffic network analysis with cost-based shortest, fastest, and optimal path algorithms. GIS C 10–17
ganos_pointcloud 7.0 Provides storage, computing, and analysis features for point clouds. GIS C 10–17
ganos_pointcloud_geometry 7.0 Integrates GanosBase PointCloud types with geometry for spatial analysis. GIS C 10–17
ganos_raster 7.0 Provides storage, computing, and analysis features for spatial raster data. GIS C 10–17
ganos_tiger_geocoder 7.0 Ganos tiger geocoder and reverse geocoder with support for USCB TIGER data. GIS C 10–17
ganos_trajectory 7.0 Models, queries, and analyzes moving-object trajectories across space and time. GIS C 10–17
gis_objects 1.0 Postgres extension for Point, Polygon, and Point-in-Polygon operations in C GIS C
hyperspace 1.0 Four-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. GIS C 15
ipinfo 1.0.1 IP geolocation lookup functions backed by the ipinfo.io HTTP service. GIS Apache-2.0 C