PrettyCompact - ClickHouse Documentation

Input	Output	Alias
✗	✔

Description

Differs from the Pretty format in that the table is displayed with a grid drawn between rows. Because of this the result is more compact.

This format is used by default in the command-line client in interactive mode.

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`