pg_lake_table

pg_lake : Data lake tables and Iceberg tables

Overview

Packages

Source

pig build pkg pg_lake;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_lake;		# install via package name, for the active PG version
pig install pg_lake_table;		# install by extension name, for the current active PG version

pig install pg_lake_table -v 18;   # install for PG 18
pig install pg_lake_table -v 17;   # install for PG 17
pig install pg_lake_table -v 16;   # install for PG 16

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pg_extension_base';

Create this extension with:

CREATE EXTENSION pg_lake_table CASCADE; -- requires btree_gist, pg_lake_engine, pg_lake_iceberg

Usage

Sources:

• Official upstream README

pg_lake_table — Data lake tables and Iceberg tables

The reviewed catalog snapshot records version 3.4, kind preload, and implementation language C. Install and validate the declared extension dependencies first: btree_gist, pg_lake_engine, pg_lake_iceberg. The curated compatibility set is 16,17,18; confirm the exact build against the target server.

CREATE EXTENSION "pg_lake_table";
SELECT extversion
FROM pg_extension
WHERE extname = 'pg_lake_table';

The upstream project is associated with Snowflake; verify its current support, license, packaging, and deployment boundary from the linked source.

The curated lifecycle is active. Pin the reviewed build and verify maintenance status before adoption.

Before production use, review the linked control/SQL or provider documentation, verify privileges and compatibility, and test the actual API and failure behavior on the target PostgreSQL build.