Results of 1 - 2 of about 2 for rendering (0.001 sec.)
- Output Formats 11228
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...results in duckbox mode, which is a feature-rich ASCII-art style output format. The duckbox mode supports the large_number_rendering option, which allows human-readable rendering of large numbers. It has three levels: off – All numbers are printed using r...ow results. all - All large numbers are replaced with the human-readable format. See the following examples: .large_number_rendering off SELECT pi() * 1_000_000_000 AS x; ┌───────────────────┐ │ x │ │ double │ ├───────────────────┤ │ 3141592653.589793 │ └...───────────────────┘ .large_number_rendering footer SELECT pi() * 1_000_000_000 AS x; ┌───────────────────┐ │ x │ │ double │ ├───────────────────┤ │ 3141592653.589793... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Dot Commands 7485
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...CTORY⟩ Change the working directory to DIRECTORY .changes ⟨on/off⟩ Show number of rows changed by SQL .columns Column-wise rendering of query results .connect_command ⟨COMMAND⟩ Set the command executed by the -connect argument .databases List names and fi...les of attached databases .decimal_sep ⟨SEP⟩ Set the decimal separator used when rendering numbers. Only for duckbox mode .dump ⟨TABLE⟩ Render database content as SQL. TABLE is a LIKE pattern for the tables to dum...ta from FILE into TABLE . Supports --csv , --json , --parquet options .indexes ⟨TABLE⟩ Show names of indexes .large_number_rendering ⟨all/footer/off⟩ Toggle readable rendering of large numbers (duckbox only, default: footer ) .last Render the last result... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work