v.21.12Improvements
Allow Multiple PostgreSQL Schemas for MaterializedPostgreSQL Database
Allow to specify one or any number of PostgreSQL schemas for one MaterializedPostgreSQL database. Closes #28901. Closes #29324. #28933 (Kseniia Sumarokova).Why it matters
This feature enables users to synchronize tables from multiple PostgreSQL schemas into a single ClickHouseMaterializedPostgreSQL database, improving flexibility and usability when dealing with diverse schema setups in PostgreSQL.How to use it
When creating aMaterializedPostgreSQL database, specify the desired schema or schemas from PostgreSQL by listing them in the configuration. This allows ClickHouse to materialize data from one or multiple schemas transparently.