v.21.1Improvements

New Commands in clickhouse-client: \l, \d, \c Added Like MySQL and PostgreSQL

Added \l, \d, \c commands in clickhouse-client like in MySQL and PostgreSQL. #30876 (Pavel Medvedev).
Added new interactive commands \l, \d, and \c to the clickhouse-client interface, similar to those found in MySQL and PostgreSQL clients.

Why it matters

These commands improve the usability of clickhouse-client by providing users with convenient shortcuts for common database tasks: listing databases (\l), describing tables (\d), and connecting to a different database (\c). This brings familiarity and efficiency for users coming from other SQL clients.

How to use it

In the clickhouse-client, simply type the commands \l, \d <table_name>, or \c <database_name> at the prompt to list databases, describe tables, or switch databases respectively. No additional configuration is required.