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.

mobilitydb_datagen · MobilityDB random data generator functions · 1.3.0 · Geospatial · PostgreSQL · SQL · Packagedgeoip · IP-based geolocation query · 0.3.0 · Geospatial · BSD-2-Clause · SQL · Packagedpgh_consistency · Pfafstetter consistency checks for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_hgm · Hydrogeomorphological analysis extension for PgHydro · 2.2.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_output · Output and reporting objects for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_output_en_au · Australian English output pack for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_output_pt_br · Brazilian Portuguese output pack for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpgh_raster · Raster hydrology extension for PgHydro · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedpghydro · Drainage network analysis core for PostgreSQL and PostGIS · 6.6 · Geospatial · GPL-2.0 · SQL · Packagedlostgis · LostGIS spatial helper functions and types · 1.0.2 · Geospatial · BSD-3-Clause · SQL · Not packagedcdb_geocoder · Archived CARTO geocoder extension for administrative, postal, IP, and named-place lookups. · 0.0.2 · Geospatial · Unknown · SQL · Not packagedast_postgis · Advanced spatial data types and spatial integrity constraints for PostGIS. · 1.1.1 · Geospatial · MIT · SQL · Not 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 packagedhistorical_geocoding · SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence. · 1.0 · Geospatial · MIT · SQL · Not packagedpostgis_letters · convert text letters into PostGIS geometries using packaged vector fonts · 0.0.5 · Geospatial · MIT · SQL · Not packagedgeoip2lookup · Look up IP-address info in MaxMind GeoIP2 MMDB files · 0.0.3 · Geospatial · BSD-2-Clause · 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 packagedbrin4postgis · BRIN indexes for PostGIS · 0.0.1 · Geospatial · GPL-3.0 · SQL · Not packagedgeohistorical_objects · Geohistorical objects support · 1.0 · Geospatial · MIT · SQL · Not packagedlivewire · power delivery modeling · 0.2.0 · Geospatial · Unknown · SQL · Not packagedpg_tms · functions to tile rasters in TMS format · 0.0.4 · Geospatial · MIT · SQL · 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 packagedpostgis_domains · Define reusable PostGIS geometry and geography domains constrained to valid, simple SRID 4326 values · 1.0 · Geospatial · MIT · SQL · Not packagedmastermobilitydb · Schema, types, and utilities for managing moving-object trajectories with MobilityDB. · 1.0.0 · Geospatial · Unknown · SQL · Not packagednfiesta_gisdata · nfi gisdata database · 3.0.7 · Geospatial · Unknown · SQL · Not packagednfiesta_target_data · PostgreSQL extension for manipulation of target data - aggregation of local density contributions at the plot level. · 2.33.2 · Geospatial · Unknown · SQL · Not packagedpg_osgr · Ordnance Survey grid reference handling for biological recording · 1.1.0 · Geospatial · Unknown · SQL · Not packagedpg_wui · PostgreSQL extension for wildland urban interface data analysis using SIOSE databases · 0.2 · Geospatial · GPL-3.0 · SQL · Not packaged

33 extensions found. Clear filters

NameVersionDescriptionCategoryLicenseLanguagePG VersionStars
mobilitydb_datagen 1.3.0 MobilityDB random data generator functions GIS PostgreSQL SQL 14–18 624
geoip 0.3.0 IP-based geolocation query GIS BSD-2-Clause SQL 14–18 52
pgh_consistency 6.6 Pfafstetter consistency checks for PgHydro GIS GPL-2.0 SQL 14–18 47
pgh_hgm 2.2.6 Hydrogeomorphological analysis extension for PgHydro GIS GPL-2.0 SQL 14–18 47
pgh_output 6.6 Output and reporting objects for PgHydro GIS GPL-2.0 SQL 14–18 47
pgh_output_en_au 6.6 Australian English output pack for PgHydro GIS GPL-2.0 SQL 14–18 47
pgh_output_pt_br 6.6 Brazilian Portuguese output pack for PgHydro GIS GPL-2.0 SQL 14–18 47
pgh_raster 6.6 Raster hydrology extension for PgHydro GIS GPL-2.0 SQL 14–18 47
pghydro 6.6 Drainage network analysis core for PostgreSQL and PostGIS GIS GPL-2.0 SQL 14–18 47
lostgis 1.0.2 LostGIS spatial helper functions and types GIS BSD-3-Clause SQL 10–18 26
cdb_geocoder 0.0.2 Archived CARTO geocoder extension for administrative, postal, IP, and named-place lookups. GIS SQL 25
ast_postgis 1.1.1 Advanced spatial data types and spatial integrity constraints for PostGIS. GIS MIT SQL 15–17 18
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
historical_geocoding 1.0 SQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence. GIS MIT SQL 5
postgis_letters 0.0.5 convert text letters into PostGIS geometries using packaged vector fonts GIS MIT SQL 10–18 5
geoip2lookup 0.0.3 Look up IP-address info in MaxMind GeoIP2 MMDB files GIS BSD-2-Clause SQL 10–18 4
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
brin4postgis 0.0.1 BRIN indexes for PostGIS GIS GPL-3.0 SQL 10–18 2
geohistorical_objects 1.0 Geohistorical objects support GIS MIT SQL 2
livewire 0.2.0 power delivery modeling GIS SQL 10 2
pg_tms 0.0.4 functions to tile rasters in TMS format GIS MIT SQL 10–18 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
postgis_domains 1.0 Define reusable PostGIS geometry and geography domains constrained to valid, simple SRID 4326 values GIS MIT SQL 10 1
mastermobilitydb 1.0.0 Schema, types, and utilities for managing moving-object trajectories with MobilityDB. GIS SQL
nfiesta_gisdata 3.0.7 nfi gisdata database GIS SQL
nfiesta_target_data 2.33.2 PostgreSQL extension for manipulation of target data - aggregation of local density contributions at the plot level. GIS SQL
pg_osgr 1.1.0 Ordnance Survey grid reference handling for biological recording GIS SQL
pg_wui 0.2 PostgreSQL extension for wildland urban interface data analysis using SIOSE databases GIS GPL-3.0 SQL