v.23.5Improvement

Add UUID Data Type to PostgreSQL

Add UUID data type to PostgreSQL. Closes #49739. #49894 (Nikolay Degterinsky).
Introduces support for the UUID data type in the PostgreSQL integration of ClickHouse.

Why it matters

This feature enables ClickHouse to properly handle and recognize UUID 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 the UUID 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.