v.21.1New Features

ClickHouse Client Adds EDITOR Support for Command Editing

Official CH changelog text
Now clickhouse-client supports opening EDITOR to edit commands. Alt-Shift-E. #17665 (Amos Bird).
The clickhouse-client now supports opening the user's default editor to edit commands via a new keyboard shortcut.

Why it matters

This feature allows users to conveniently edit complex or lengthy SQL commands in their preferred text editor, improving workflow efficiency and command accuracy when using the ClickHouse command-line client.

How to use it

Within clickhouse-client, press Alt-Shift-E to open the default system editor (defined by the EDITOR environment variable) with the current command loaded. After editing and saving, the command will be executed.

Related resources

PreviousNext