v.20.10New Feature

Add output_format_pretty_row_numbers setting for Pretty formats

Add a setting output_format_pretty_row_numbers to numerate the result in Pretty formats. This closes #15350. #15443 (flynn).
Added a setting output_format_pretty_row_numbers that enables automatic row numbering in Pretty output formats.

Why it matters

This feature addresses the need to easily identify and refer to individual rows in query results formatted with Pretty output. It improves readability and traceability by numerating rows, which is particularly valuable when working with human-friendly tabular outputs.

How to use it

To use this feature, set the setting output_format_pretty_row_numbers to 1 (true) in the session or query settings before executing your query. For example:

SET output_format_pretty_row_numbers = 1;
SELECT * FROM table;

This will display the result with row numbers in Pretty output formats.