v.21.12Improvements
New Commands in clickhouse-client: \l, \d, \c Added Like MySQL and PostgreSQL
Added\l,\d,\ccommands inclickhouse-clientlike in MySQL and PostgreSQL. #30876 (Pavel Medvedev).
Why it matters
These commands improve the usability ofclickhouse-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 theclickhouse-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.