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).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 settingoutput_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.