Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

PrettySpace

Input Output Alias

Description

Differs from the PrettyCompact format in that whitespace (space characters) is used for displaying the table instead of a grid.

Example usage

Format settings

The following settings are common to all Pretty formats:

Setting Description Default
output_format_pretty_max_rows Row limit for Pretty formats. 10000
output_format_pretty_max_column_pad_width Maximum width to pad all values in a column in Pretty formats. 250
output_format_pretty_max_value_width Maximum width of value to display in Pretty formats. If greater - it will be cut. 10000
output_format_pretty_color Use ANSI escape sequences to paint colors in Pretty formats. true
output_format_pretty_grid_charset Charset for printing grid borders. Available charsets: ASCII, UTF-8. UTF-8
output_format_pretty_row_numbers Add row numbers before each row for pretty output format. true
output_format_pretty_display_footer_column_names Display column names in the footer if table contains many rows. true
output_format_pretty_display_footer_column_names_min_rows Sets the minimum number of rows for which a footer will be displayed if output_format_pretty_display_footer_column_names is enabled. 50
Navigation