v.22.4Improvement

Support UUID for Postgres Engines

Support uuid for Postgres engines. Closes #35384. #35403 (Kseniia Sumarokova).
ClickHouse now supports the UUID data type for Postgres table engines.

Why it matters

This feature allows users to seamlessly integrate and query Postgres tables that contain UUID columns, enhancing compatibility and functionality when using the Postgres engine in ClickHouse.

How to use it

When creating or attaching a Postgres table in ClickHouse with ENGINE = Postgres, you can now define columns with the UUID data type to match the Postgres schema. This enables direct querying and data handling of UUID fields without additional conversions.