v.21.7Improvement

PostgreSQL Support for Specifying Non-Default Schema in Insert Queries

PostgreSQL support for specifying non default schema for insert queries. Closes #24149. #24413 (Kseniia Sumarokova).
Added support for specifying a non-default schema in PostgreSQL insert queries in ClickHouse.

Why it matters

This feature enables users to insert data into PostgreSQL tables that reside in schemas other than the default one, improving flexibility and compatibility when working with PostgreSQL data sources.

How to use it

When performing insert queries to PostgreSQL, specify the target schema explicitly in the insert statement or connection settings to direct the data to the desired schema instead of the default one.