↑↓ 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
pgr_dmmsy 0.1.0 DMMSY deterministic directed single-source shortest path algorithm for pgRouting GIS — C 14–16
sgp4 0.1 C extension that propagates satellite TLEs with SGP4 and returns WGS84 position as WKT. GIS MIT C —