Results of 1 - 10 of about 18 for display (0.002 sec.)
- Dot Commands 15270
- 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
...mbers. Only for duckbox mode .dump ⟨TABLE⟩ Render database content as SQL. TABLE is a LIKE pattern for the tables to dump .display_colors ⟨bold/underline⟩ Display all terminal colors and their names. See the 8-bit colors section .echo ⟨on/off⟩ Turn comm...edit Open an external text editor to edit a query. \e can be used as an alias. See the external editor mode section .excel Display the output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this program with return-code CO...DE .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 shortc... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Friendly CLI 9025
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
...de duckdb -light-mode 8-Bit Colors Since DuckDB 1.5, the CLI supports 8-bit colors corresponding to Xterm system colors : .display_colors darkred1 red darkred2 red3 red4 red1 brightred indianred1 ... Dynamic Prompt The default prompt is the following: {... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Syntax Highlighting 9025
- Syntax highlighting in the CLI is available for macOS, Linux and Windows. SQL queries that are written in the shell are automatically highlighted using syntax highlighting. There are several components of a query that are highlighted in dif
..., brightgreen , brightyellow , brightblue , brightmagenta , brightcyan , white In addition, 8-bit colors can be used. Run .display_colors to list all available color names, see 8-Bit Colors . The optional intensity can be standard , bold , underline or... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
- EXPLAIN: Inspect Query Plans 8836
- EXPLAIN SELECT * FROM tbl; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a
...h is calculated by using the statistics of the base tables and applying heuristics for each operator. Table scan operators display the fully qualified table name including catalog and schema (e.g., memory.main.exams ). Additional Explain Settings The EX... - https://man.mtool.work/duckdb/2.0/guides/meta/explain.html
- Relational API 8647
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...it runs again on every read, so each read sees the current data. Printing a relation, or calling show() , also runs it and displays the first rows: import duckdb duckdb_conn = duckdb.connect() rel = duckdb_conn.sql("FROM range(1_000_000_000) t(id) SELEC...lation object. set_alias Rename the relation object to new alias. shape Tuple of # of rows, # of columns in relation. show Display a summary of the data. sql_query Get the SQL query that is equivalent to the relation; values given as params= stay marker...s: int | None = None, max_col_width: int | None = None, null_value: str | None = None, render_mode: object = None) -> None Display a summary of the data. Parameters max_width : int, keyword-only, default: None Maximum display width for the entire output... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- Configuration 8459
- Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. The configuration object should be created, filled with val
...get_config_flag Obtains a human-readable name and description of a specific configuration option. This can be used to e.g. display configuration options. This will succeed unless index is out of range (i.e., >= duckdb_config_count ). The result name or... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- ODBC API on Windows 8459
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...g DuckDB DSN When selecting the default DSN (i.e., DuckDB ) or adding a new configuration, the following setup window will display: This window allows you to set the DSN and the database file path associated with that DSN. More Detailed Windows Setup Th... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- Timestamp Issues 8459
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...ed to promote the date to midnight in the current time zone . In general, unless you need to use the current time zone for display (or other temporal binning operations) you should use plain TIMESTAMP s for temporal data. This will avoid confusing issue... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
- Output Formats 8270
- 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
...d the latex mode is useful for writing academic papers. Warning Unicode handling in Windows Terminal When long results are displayed in Windows Terminal the more system utility is used by default to provide the scrolling through the results. This utilit...y has incomplete support of Unicode, depending on the output data, in some cases it can display Unicode characters in garbled form. We suggest using the third-party less utility instead, that is installed by default al...LI supports paging for large result sets using the .pager command. When enabled, results that exceed the terminal size are displayed in a pager (such as less ) for easier navigation. The pager has three modes: automatic (default) – The pager is triggere... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- Benchmark Suite 8270
- DuckDB has an extensive benchmark suite. When making changes that have potential performance implications, it is important to run these benchmarks to detect potential performance regressions. Getting Started To build the benchmark suite, ru
...ion about the benchmark. build/release/benchmark/benchmark_runner benchmark/micro/nulls/no_nulls_addition.benchmark --info display_name:NULL Addition (no nulls) group:micro subgroup:nulls The --query flag will print the query that is run by the benchmar... - https://man.mtool.work/duckdb/2.0/dev/benchmark.html
DuckDB 2.0 Documentation / man.mtool.work