Adds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_lake |
|---|---|
| Version | 3.5 |
| PostgreSQL versions | 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | pg_catalog |
| Stars | 1,630 |
| Latest commit | 2026-08-28 |
| Latest release | 2026-07-28 |
| Catalogue updated | 2026-09-19 |
| postgis | PostGIS geometry and geography spatial types and functions |
| plv8geo | PL/v8 geospatial functions that bundle D3, TopoJSON, JSTS, GeoTIFF and related JavaScript libraries for PostGIS workflows. |
| pgh3 | Expose Uber H3 hierarchical geospatial indexing functions for PostGIS geometries |
| qdgc | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
| pg_twkb | TWKB tools etc |
| ast_postgis | Advanced spatial data types and spatial integrity constraints for PostGIS. |
| pg_geohash | Handle geohash based functionality for spatial coordinates |
| firefly | PostGIS-backed Firefly database schema for tracking 3D points and add/delete operations by task. |
| pg_lake | Data lake extension by Snowflake |
| pg_extension_base | Extension development kit by Snowflake |
| pg_extension_updater | Automatic extension updater |
| pg_map | Map type for PostgreSQL, bundled as a required pg_lake component. |
| pg_lake_engine | Query engine for data lake queries |
| pg_lake_iceberg | Iceberg implementation in Postgres |
| pg_lake_table | Data lake tables and Iceberg tables |
| pg_lake_copy | Copy to/from data lake files |
| pg_lake_benchmark | Provides ClickBench, TPC-H and TPC-DS data generation and benchmark queries for pg_lake, Iceberg and heap tables. |