swt30

FROM postgres:17.2 AS postgres
RUN echo "create table test as (select '2025-01-02 03:04:05.678900'::timestamptz as ts, '2025-01-02'::date as d);" > /docker-entrypoint-initdb.d/table.sql

FROM clickhouse/clickhouse-server:25.1.3.23 AS clickhouse
# FROM clickhouse/clickhouse-server:24.12 AS clickhouse
RUN echo "create table test (ts DateTime64(6, 'UTC'), d Date) engine = PostgreSQL('postgres:5432', 'postgres', 'test', 'postgres', 'password')" > /docker-entrypoint-initdb.d/postgres.sql