v.21.9Improvement

Support for PostgreSQL Database Engine Schema

Support schema for PostgreSQL database engine. Closes #27166. #27198 (Kseniia Sumarokova).
Support schema for PostgreSQL database engine in ClickHouse.

Why it matters

This feature adds schema support for the PostgreSQL database engine in ClickHouse. It addresses the lack of schema handling when working with PostgreSQL as an external data source, enabling more accurate and flexible querying by respecting PostgreSQL schemas. This improves interoperability and eases integration between ClickHouse and PostgreSQL databases.

How to use it

When configuring a PostgreSQL database engine in ClickHouse, specify the schema name in your external table definitions or database configurations to enable schema-aware queries. This makes it possible to reference tables using their schema-qualified names, improving query precision and compatibility.