Extensions
pg_clickhouse

pg_clickhouse

pg_clickhouse : Interfaces to query ClickHouse databases from PostgreSQL

Overview

ID Extension Package Version Category License Language
2460
pg_clickhouse
pg_clickhouse
 0.1.4
OLAP
Apache-2.0
C++
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
pg_duckdb
duckdb_fdw
citus
columnar
citus_columnar
clickhouse_fdw
postgres_fdw
dblink

with submodule

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 0.1.4
18
17
16
15
14
13
 pg_clickhouse -
RPM
PIGSTY
 0.1.4
18
17
16
15
14
13
 pg_clickhouse_$v -
DEB
PIGSTY
 0.1.4
18
17
16
15
14
13
 postgresql-$v-clickhouse -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
el8.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
el9.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
el9.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
el10.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
el10.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
d12.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
d12.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
d13.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
d13.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
u22.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
u22.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
u24.x86_64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
u24.aarch64
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
PIGSTY 0.1.4
Package Version OS ORG SIZE File URL
pg_clickhouse_18 0.1.4 el8.x86_64 pigsty 705.4 KiB pg_clickhouse_18-0.1.4-1PIGSTY.el8.x86_64.rpm
pg_clickhouse_18 0.1.4 el8.aarch64 pigsty 629.2 KiB pg_clickhouse_18-0.1.4-1PIGSTY.el8.aarch64.rpm
pg_clickhouse_18 0.1.4 el9.x86_64 pigsty 712.3 KiB pg_clickhouse_18-0.1.4-1PIGSTY.el9.x86_64.rpm
pg_clickhouse_18 0.1.4 el9.aarch64 pigsty 681.9 KiB pg_clickhouse_18-0.1.4-1PIGSTY.el9.aarch64.rpm
pg_clickhouse_18 0.1.4 el10.x86_64 pigsty 736.5 KiB pg_clickhouse_18-0.1.4-1PIGSTY.el10.x86_64.rpm
pg_clickhouse_18 0.1.4 el10.aarch64 pigsty 700.0 KiB pg_clickhouse_18-0.1.4-1PIGSTY.el10.aarch64.rpm
postgresql-18-clickhouse 0.1.4 d12.x86_64 pigsty 818.5 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~bookworm_amd64.deb
postgresql-18-clickhouse 0.1.4 d12.aarch64 pigsty 758.2 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~bookworm_arm64.deb
postgresql-18-clickhouse 0.1.4 d13.x86_64 pigsty 822.7 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~trixie_amd64.deb
postgresql-18-clickhouse 0.1.4 d13.aarch64 pigsty 762.3 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~trixie_arm64.deb
postgresql-18-clickhouse 0.1.4 u22.x86_64 pigsty 888.0 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~jammy_amd64.deb
postgresql-18-clickhouse 0.1.4 u22.aarch64 pigsty 861.4 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~jammy_arm64.deb
postgresql-18-clickhouse 0.1.4 u24.x86_64 pigsty 901.1 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~noble_amd64.deb
postgresql-18-clickhouse 0.1.4 u24.aarch64 pigsty 869.3 KiB postgresql-18-clickhouse_0.1.4-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_clickhouse_17 0.1.4 el8.x86_64 pigsty 705.1 KiB pg_clickhouse_17-0.1.4-1PIGSTY.el8.x86_64.rpm
pg_clickhouse_17 0.1.4 el8.aarch64 pigsty 629.2 KiB pg_clickhouse_17-0.1.4-1PIGSTY.el8.aarch64.rpm
pg_clickhouse_17 0.1.4 el9.x86_64 pigsty 712.1 KiB pg_clickhouse_17-0.1.4-1PIGSTY.el9.x86_64.rpm
pg_clickhouse_17 0.1.4 el9.aarch64 pigsty 682.2 KiB pg_clickhouse_17-0.1.4-1PIGSTY.el9.aarch64.rpm
pg_clickhouse_17 0.1.4 el10.x86_64 pigsty 736.1 KiB pg_clickhouse_17-0.1.4-1PIGSTY.el10.x86_64.rpm
pg_clickhouse_17 0.1.4 el10.aarch64 pigsty 699.6 KiB pg_clickhouse_17-0.1.4-1PIGSTY.el10.aarch64.rpm
postgresql-17-clickhouse 0.1.4 d12.x86_64 pigsty 818.7 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~bookworm_amd64.deb
postgresql-17-clickhouse 0.1.4 d12.aarch64 pigsty 756.9 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~bookworm_arm64.deb
postgresql-17-clickhouse 0.1.4 d13.x86_64 pigsty 822.9 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~trixie_amd64.deb
postgresql-17-clickhouse 0.1.4 d13.aarch64 pigsty 761.9 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~trixie_arm64.deb
postgresql-17-clickhouse 0.1.4 u22.x86_64 pigsty 937.1 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~jammy_amd64.deb
postgresql-17-clickhouse 0.1.4 u22.aarch64 pigsty 909.8 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~jammy_arm64.deb
postgresql-17-clickhouse 0.1.4 u24.x86_64 pigsty 900.6 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~noble_amd64.deb
postgresql-17-clickhouse 0.1.4 u24.aarch64 pigsty 868.0 KiB postgresql-17-clickhouse_0.1.4-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_clickhouse_16 0.1.4 el8.x86_64 pigsty 705.0 KiB pg_clickhouse_16-0.1.4-1PIGSTY.el8.x86_64.rpm
pg_clickhouse_16 0.1.4 el8.aarch64 pigsty 629.1 KiB pg_clickhouse_16-0.1.4-1PIGSTY.el8.aarch64.rpm
pg_clickhouse_16 0.1.4 el9.x86_64 pigsty 712.3 KiB pg_clickhouse_16-0.1.4-1PIGSTY.el9.x86_64.rpm
pg_clickhouse_16 0.1.4 el9.aarch64 pigsty 681.8 KiB pg_clickhouse_16-0.1.4-1PIGSTY.el9.aarch64.rpm
pg_clickhouse_16 0.1.4 el10.x86_64 pigsty 736.2 KiB pg_clickhouse_16-0.1.4-1PIGSTY.el10.x86_64.rpm
pg_clickhouse_16 0.1.4 el10.aarch64 pigsty 699.7 KiB pg_clickhouse_16-0.1.4-1PIGSTY.el10.aarch64.rpm
postgresql-16-clickhouse 0.1.4 d12.x86_64 pigsty 819.1 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~bookworm_amd64.deb
postgresql-16-clickhouse 0.1.4 d12.aarch64 pigsty 757.2 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~bookworm_arm64.deb
postgresql-16-clickhouse 0.1.4 d13.x86_64 pigsty 822.2 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~trixie_amd64.deb
postgresql-16-clickhouse 0.1.4 d13.aarch64 pigsty 762.1 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~trixie_arm64.deb
postgresql-16-clickhouse 0.1.4 u22.x86_64 pigsty 934.0 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~jammy_amd64.deb
postgresql-16-clickhouse 0.1.4 u22.aarch64 pigsty 906.3 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~jammy_arm64.deb
postgresql-16-clickhouse 0.1.4 u24.x86_64 pigsty 900.7 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~noble_amd64.deb
postgresql-16-clickhouse 0.1.4 u24.aarch64 pigsty 868.5 KiB postgresql-16-clickhouse_0.1.4-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_clickhouse_15 0.1.4 el8.x86_64 pigsty 708.2 KiB pg_clickhouse_15-0.1.4-1PIGSTY.el8.x86_64.rpm
pg_clickhouse_15 0.1.4 el8.aarch64 pigsty 630.8 KiB pg_clickhouse_15-0.1.4-1PIGSTY.el8.aarch64.rpm
pg_clickhouse_15 0.1.4 el9.x86_64 pigsty 714.7 KiB pg_clickhouse_15-0.1.4-1PIGSTY.el9.x86_64.rpm
pg_clickhouse_15 0.1.4 el9.aarch64 pigsty 683.9 KiB pg_clickhouse_15-0.1.4-1PIGSTY.el9.aarch64.rpm
pg_clickhouse_15 0.1.4 el10.x86_64 pigsty 739.6 KiB pg_clickhouse_15-0.1.4-1PIGSTY.el10.x86_64.rpm
pg_clickhouse_15 0.1.4 el10.aarch64 pigsty 702.8 KiB pg_clickhouse_15-0.1.4-1PIGSTY.el10.aarch64.rpm
postgresql-15-clickhouse 0.1.4 d12.x86_64 pigsty 820.7 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~bookworm_amd64.deb
postgresql-15-clickhouse 0.1.4 d12.aarch64 pigsty 758.6 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~bookworm_arm64.deb
postgresql-15-clickhouse 0.1.4 d13.x86_64 pigsty 823.3 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~trixie_amd64.deb
postgresql-15-clickhouse 0.1.4 d13.aarch64 pigsty 762.9 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~trixie_arm64.deb
postgresql-15-clickhouse 0.1.4 u22.x86_64 pigsty 936.0 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~jammy_amd64.deb
postgresql-15-clickhouse 0.1.4 u22.aarch64 pigsty 907.9 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~jammy_arm64.deb
postgresql-15-clickhouse 0.1.4 u24.x86_64 pigsty 903.0 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~noble_amd64.deb
postgresql-15-clickhouse 0.1.4 u24.aarch64 pigsty 870.0 KiB postgresql-15-clickhouse_0.1.4-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_clickhouse_14 0.1.4 el8.x86_64 pigsty 708.0 KiB pg_clickhouse_14-0.1.4-1PIGSTY.el8.x86_64.rpm
pg_clickhouse_14 0.1.4 el8.aarch64 pigsty 630.9 KiB pg_clickhouse_14-0.1.4-1PIGSTY.el8.aarch64.rpm
pg_clickhouse_14 0.1.4 el9.x86_64 pigsty 714.3 KiB pg_clickhouse_14-0.1.4-1PIGSTY.el9.x86_64.rpm
pg_clickhouse_14 0.1.4 el9.aarch64 pigsty 684.1 KiB pg_clickhouse_14-0.1.4-1PIGSTY.el9.aarch64.rpm
pg_clickhouse_14 0.1.4 el10.x86_64 pigsty 739.9 KiB pg_clickhouse_14-0.1.4-1PIGSTY.el10.x86_64.rpm
pg_clickhouse_14 0.1.4 el10.aarch64 pigsty 702.9 KiB pg_clickhouse_14-0.1.4-1PIGSTY.el10.aarch64.rpm
postgresql-14-clickhouse 0.1.4 d12.x86_64 pigsty 819.9 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~bookworm_amd64.deb
postgresql-14-clickhouse 0.1.4 d12.aarch64 pigsty 758.4 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~bookworm_arm64.deb
postgresql-14-clickhouse 0.1.4 d13.x86_64 pigsty 823.3 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~trixie_amd64.deb
postgresql-14-clickhouse 0.1.4 d13.aarch64 pigsty 762.9 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~trixie_arm64.deb
postgresql-14-clickhouse 0.1.4 u22.x86_64 pigsty 935.6 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~jammy_amd64.deb
postgresql-14-clickhouse 0.1.4 u22.aarch64 pigsty 907.5 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~jammy_arm64.deb
postgresql-14-clickhouse 0.1.4 u24.x86_64 pigsty 902.6 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~noble_amd64.deb
postgresql-14-clickhouse 0.1.4 u24.aarch64 pigsty 869.4 KiB postgresql-14-clickhouse_0.1.4-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_clickhouse_13 0.1.4 el8.x86_64 pigsty 707.5 KiB pg_clickhouse_13-0.1.4-1PIGSTY.el8.x86_64.rpm
pg_clickhouse_13 0.1.4 el8.aarch64 pigsty 630.9 KiB pg_clickhouse_13-0.1.4-1PIGSTY.el8.aarch64.rpm
pg_clickhouse_13 0.1.4 el9.x86_64 pigsty 714.8 KiB pg_clickhouse_13-0.1.4-1PIGSTY.el9.x86_64.rpm
pg_clickhouse_13 0.1.4 el9.aarch64 pigsty 684.1 KiB pg_clickhouse_13-0.1.4-1PIGSTY.el9.aarch64.rpm
pg_clickhouse_13 0.1.4 el10.x86_64 pigsty 739.4 KiB pg_clickhouse_13-0.1.4-1PIGSTY.el10.x86_64.rpm
pg_clickhouse_13 0.1.4 el10.aarch64 pigsty 703.1 KiB pg_clickhouse_13-0.1.4-1PIGSTY.el10.aarch64.rpm
postgresql-13-clickhouse 0.1.4 d12.x86_64 pigsty 820.4 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~bookworm_amd64.deb
postgresql-13-clickhouse 0.1.4 d12.aarch64 pigsty 758.3 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~bookworm_arm64.deb
postgresql-13-clickhouse 0.1.4 d13.x86_64 pigsty 823.3 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~trixie_amd64.deb
postgresql-13-clickhouse 0.1.4 d13.aarch64 pigsty 762.8 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~trixie_arm64.deb
postgresql-13-clickhouse 0.1.4 u22.x86_64 pigsty 934.8 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~jammy_amd64.deb
postgresql-13-clickhouse 0.1.4 u22.aarch64 pigsty 906.7 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~jammy_arm64.deb
postgresql-13-clickhouse 0.1.4 u24.x86_64 pigsty 903.0 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~noble_amd64.deb
postgresql-13-clickhouse 0.1.4 u24.aarch64 pigsty 869.7 KiB postgresql-13-clickhouse_0.1.4-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/ClickHouse/pg_clickhouse
 Source Tarball
pg_clickhouse-0.1.4.tar.gz
 
pig build pkg pg_clickhouse;		# 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_clickhouse;		# install via package name, for the active PG version

pig install pg_clickhouse -v 18;   # install for PG 18
pig install pg_clickhouse -v 17;   # install for PG 17
pig install pg_clickhouse -v 16;   # install for PG 16
pig install pg_clickhouse -v 15;   # install for PG 15
pig install pg_clickhouse -v 14;   # install for PG 14
pig install pg_clickhouse -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_clickhouse;
Last updated on
pg_mooncakeduckdb_fdw