title_wip

[Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/interfaces/formats/Pretty/PrettyNoEscapes.md)

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Input Output Alias|  |  |  | | --- | --- | --- | | ✗ ✔  | | | | | |

## Description[​](#description "Direct link to Description")

Differs from [Pretty](/docs/interfaces/formats/Pretty) in that [ANSI-escape sequences](https://en.wikipedia.org/wiki/ANSI_escape_code) aren't used.
This is necessary for displaying the format in a browser, as well as for using the 'watch' command-line utility.

## Example usage[​](#example-usage "Direct link to Example usage")

Example:

```
$ watch -n1 "clickhouse-client --query='SELECT event, value FROM system.events FORMAT PrettyCompactNoEscapes'"
```

Note

The [HTTP interface](/docs/interfaces/http) can be used for displaying this format in the browser.

## Format settings[​](#format-settings "Direct link to Format settings")

The following settings are common to all `Pretty` formats:

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Description Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [`output_format_pretty_max_rows`](/docs/operations/settings/formats#output_format_pretty_max_rows) Row limit for Pretty formats. `10000`| [`output_format_pretty_max_column_pad_width`](/docs/operations/settings/formats#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`](/docs/operations/settings/formats#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`](/docs/operations/settings/formats#output_format_pretty_color) Use ANSI escape sequences to paint colors in Pretty formats. `true`| [`output_format_pretty_grid_charset`](/docs/operations/settings/formats#output_format_pretty_grid_charset) Charset for printing grid borders. Available charsets: ASCII, UTF-8. `UTF-8`| [`output_format_pretty_row_numbers`](/docs/operations/settings/formats#output_format_pretty_row_numbers) Add row numbers before each row for pretty output format. `true`| [`output_format_pretty_display_footer_column_names`](/docs/operations/settings/formats#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`](/docs/operations/settings/formats#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`](/docs/operations/settings/formats#output_format_pretty_display_footer_column_names) is enabled. `50` | | | | | | | | | | | | | | | | | | | | | | | | | | |

- [Description](#description)- [Example usage](#example-usage)- [Format settings](#format-settings)

Was this page helpful?