v.23.5Improvement
Add UUID Data Type to PostgreSQL
Add UUID data type to PostgreSQL. Closes #49739. #49894 (Nikolay Degterinsky).
Why it matters
This feature enables ClickHouse to properly handle and recognizeUUID fields when interacting with PostgreSQL. It solves the problem of missing or incorrect UUID type support in PostgreSQL table engines, allowing seamless data exchange and improved compatibility with PostgreSQL databases using UUID columns.How to use it
Users can now use theUUID data type normally in PostgreSQL tables managed by ClickHouse. No additional configuration is required beyond defining columns with the UUID type in the corresponding PostgreSQL database or table engine definitions.