v.22.7Improvement

Support \i file in ClickHouse client similar to psql \i

Official CH changelog text
Support \i file in clickhouse client / local (similar to psql \i). #38813 (Kseniia Sumarokova).
Added support for the \i file command in the ClickHouse client and local execution mode, similar to the \i command in psql.

Why it matters

This feature allows users to execute SQL queries from a file directly within the ClickHouse client or local execution context, simplifying workflows by enabling script-based query execution without manual copy-pasting.

How to use it

In the ClickHouse client or when using clickhouse local, run the command \i <filename> to execute the SQL statements contained in the specified file.

Related resources

PreviousNext