v.23.12Improvement

Proper Handling of PostgreSQL Table Structure with Empty Array

Properly handling PostgreSQL table structure with empty array. #57618 (Mike Kot).
Properly handle PostgreSQL table structures containing empty arrays when integrating with ClickHouse.

Why it matters

This feature addresses the issue of incomplete or incorrect processing of PostgreSQL table schemas that include empty array definitions. It ensures accurate interpretation and mapping of such arrays, improving data consistency and compatibility during ingestion or synchronization from PostgreSQL to ClickHouse.

How to use it

Users benefit from this feature automatically when using ClickHouse to interface with PostgreSQL tables. No additional configuration is required; ClickHouse now correctly processes PostgreSQL tables containing empty arrays during metadata retrieval and data import.