v.23.11Improvement

Add PostgreSQL Table Engine Setting to Config File

Official CH changelog text
Add a setting for PostgreSQL table engine setting in the config file. Added a check for the setting Added documentation around the additional setting. #56959 (Peignon Melvyn).
Added a configuration file setting to control the behavior of the PostgreSQL table engine in ClickHouse.

Why it matters

This feature allows users to configure specific options for the PostgreSQL table engine directly from the ClickHouse configuration file, enabling better control and customization of how external PostgreSQL tables are accessed and managed. It improves usability and integration flexibility.

How to use it

Users can enable or adjust the PostgreSQL table engine behavior by adding the dedicated setting in the ClickHouse server configuration file under the relevant section. Refer to the updated documentation for the exact configuration key and supported options.

Related resources

PreviousNext