format
Usage
.format [format]
Description
The format command sets the format mode for the CLI. The default format mode is unicode.
| Format | Description |
|---|---|
ascii | ASCII characters to draw a table |
csv | Comma Separated Values (CSV) |
expanded | PostgreSQL Expanded Format |
html | HyperText Markup Language (HTML) |
json | JavaScript Object Notation (JSON) |
jsonl | JSON Lines (JSONL) |
markdown | Markdown |
plain | Column based layout |
psql | PostgreSQL Standard Format |
sqlite | SQLite formatted table |
tsv | Tab Separated Values (TSV) |
unicode | Unicode characters to draw a table |
xml | Extensible Markup Language (XML) |
yaml | YAML Ain’t Markup Language (YAML) |
Examples
Show the current format mode:
.format
Set the format mode to ascii:
.format ascii
Set the format mode to unicode:
.format unicode
Demonstration
