Results of 1 - 7 of about 7 for Duckbox (0.001 sec.)
- Importing Duckbox Tables 13286
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...ote that the separator is not the pipe character | , instead it is the “Box Drawings Light Vertical” character │ . Loading Duckbox Tables to DuckDB First, we save the table above as duckbox.csv . Then, we clean it using sed : echo -n > duckbox-cleaned.c...sv sed -n "2s/^│ *//;s/ *│$//;s/ *│ */│/p;2q" duckbox.csv >> duckbox-cleaned.csv sed "1,4d;\$d;s/^│ *//;s/ *│$//;s/ *│ */│/g" duckbox.csv >> duckbox-cleaned.csv The duckbox-cle...aned.csv file looks as follows: a│b hello│42 world│84 We can then simply load this to DuckDB via: FROM read_csv('duckbox-cleaned.csv', delim = '│'); And export it to a CSV: COPY (FROM read_csv('duckbox-cleaned.csv', delim = '│')) TO 'out.csv';... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- Dot Commands 9378
- 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
...t names and files 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 dump .display_colors ⟨bold/un...xit ⟨CODE⟩ Exit this program with return-code CODE .headers ⟨on/off⟩ Turn display of headers on or off . Does not apply to duckbox mode .help ⟨-all⟩ ⟨PATTERN⟩ Show help text for PATTERN . Use .help shortcuts to display keyboard shortcuts .highlight ⟨on/...de. See the dark/light mode section for details .highlight_results ⟨on/off⟩ Toggle highlighting in result tables on / off (duckbox only). See the result syntax highlighting section for more details .history ⟨N⟩ Show the command history with syntax highl... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Output Formats 9160
- 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
...and 0x1E box Tables using unicode box-drawing characters csv Comma-separated values column Output in columns (See .width ) duckbox Tables with extensive features (default) html HTML <table> code insert ⟨TABLE⟩ SQL insert statements for ⟨TABLE⟩ json Resu...g the Output Format Use the vanilla .mode dot command to query the appearance currently in use. .mode current output mode: duckbox Use the .mode dot command with an argument to set the output format. .mode markdown SELECT 'quacking intensifies' AS incom...ent: .pager less -RS The default pager command can also be configured via the DUCKDB_PAGER or PAGER environment variables. duckbox Mode By default, DuckDB renders query results in duckbox mode, which is a feature-rich ASCII-art style output format. The... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Command Line 8142
- Unexpected Markdown Output When Piping If the output of the command line client is piped to another process and an AI agent environment variable (such as AI_AGENT ) is set, the CLI switches to agent mode and prints compact Markdown tables i
...nstead of the usual duckbox tables: echo "SELECT 42 AS x;" | duckdb | cat | x:INTEGER | |---| | 42 | To turn off agent mode, use the -no-agent command... - https://man.mtool.work/duckdb/2.0/guides/troubleshooting/command_line.html
- Calculating a Database Checksum 8051
- To calculate a database checksum, use a commutative operation such as bit_xor on all columns, all rows, and all tables. First, create a table macro that performs this for each table: CREATE OR REPLACE MACRO table_checksum(table_name) AS TAB
...ntf('INSERT INTO table_checksums FROM table_checksum(''%s'');', table_name) FROM duckdb_tables() WHERE NOT internal; .mode duckbox Read the SQL file back and calculate the checksum for the database: .read checksum_all_tables.sql SELECT bit_xor(checksum)... - https://man.mtool.work/duckdb/2.0/guides/snippets/database_checksum.html
- Guides 7852
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...DB and YouPlot Snippets Creating synthetic data Dutch railway datasets Sharing macros Analyzing a Git repository Importing duckbox tables Copying an in-memory database to a file Calculating a database checksum Troubleshooting Command line Crashes Out of... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Command Line Client 7670
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...dot command may be used to change the appearance of the tables returned in the terminal output. These include the default duckbox mode, csv and json mode for ingestion by other tools, markdown and latex for documents and insert mode for generating SQL... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work