Extensions / Foreign data wrappers
ClickHouse foreign data wrapper for PostgreSQL
pgext.cloud · Source code · Documentation · License text · Control file
| Package | clickhouse_fdw |
|---|---|
| Version | 1.4 |
| PostgreSQL versions | 11 · 12 · 13 · 14 · 15 · 16 · 17 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Archived |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 275 |
| Latest commit | 2025-12-29 |
| Latest release | 2022-12-12 |
| Catalogue updated | 2026-08-30 |
| pg_clickhouse | Interfaces to query ClickHouse databases from PostgreSQL |
| clickhousedb_fdw | ClickHouse foreign data wrapper with SELECT/INSERT support plus aggregate and join pushdown. |
| ch_fdw | Foreign data wrapper for federated access from PostgreSQL to ClickHouse. |
| pg_stat_ch | Export PostgreSQL query telemetry to ClickHouse |
| duckdb_fdw | DuckDB Foreign Data Wrapper |
| re2 | ClickHouse-compatible regex functions using RE2 |
| gfs | GFS copy-on-read storage: a Table Access Method whose missing rows are fetched from the source on read and written through locally |
| kafka_fdw | kafka Foreign Data Wrapper for CSV formatted messages |
| hdfs_fdw | foreign-data wrapper for remote hdfs servers |
| pg_ai_sdk | Translate natural language to SQL using Clickhouse ai-sdk-cpp |