Map type for PostgreSQL, bundled as a required pg_lake component.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_lake |
|---|---|
| Version | 3.5 |
| PostgreSQL versions | 16 · 17 · 18 |
| Repository | PIGSTY |
| Extension type | Standard |
| Project status | Active |
| Vendor | Snowflake |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | map_type, pg_catalog |
| Stars | 1,630 |
| Latest commit | 2026-08-28 |
| Latest release | 2026-07-28 |
| Catalogue updated | 2026-09-20 |
| pg_lake_engine | Query engine for data lake queries |
| hstore | data type for storing sets of (key, value) pairs |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| collection | Associative-array data types for high-performance PL/pgSQL workflows |
| pgjq | Use jq in Postgres |
| jsquery | data type for jsonb inspection |
| intarray | functions, operators, and index support for 1-D arrays of integers |
| arraymath | Array math and operators that work element by element on the contents of arrays |
| pg_jsonschema | PostgreSQL extension providing JSON Schema validation |
| jsonschema | JSON Schema validation functions for PostgreSQL |
| pg_projection | MongoDB-like read projections for JSONB in PostgreSQL |
| pg_lake | Data lake extension by Snowflake |
| pg_extension_base | Extension development kit by Snowflake |
| pg_extension_updater | Automatic extension updater |
| 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. |
| pg_lake_spatial | Adds geospatial file-format and spatial-function support to pg_lake through PostGIS and GDAL-backed workflows. |