PostgreSQL protocol now supports the COPY command

Why it matters

This feature enables users interacting with ClickHouse via the PostgreSQL protocol to efficiently bulk load data using the widely adopted COPY command, improving compatibility and ease of data ingestion workflows.

How to use it

Users can utilize the COPY command when connected to ClickHouse through its PostgreSQL protocol interface to perform bulk data imports or exports as they would with a standard PostgreSQL server.