Results of 1 - 10 of about 27 for commands (0.002 sec.)
- Command Line Client 15684
- 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.
...This will remove the .wal file (the write-ahead log ) and consolidate all of your data into the single-file database. Dot Commands In addition to SQL syntax, special dot commands may be entered into the CLI client. To use one of these commands, begin th...r the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands must be entered on a single line, and no whitespace may occur before the period. No semicolon is required at the end of th...g the ~/.duckdbrc file, start it with the -no-init argument: batch duckdb -no-init Below, we summarize a few important dot commands. To see all available commands, see the dot commands page or use the .help command. Opening Database Files In addition to... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Dot Commands 10319
- 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
...r the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands must be entered on a single line, and no whitespace may occur before the period. No semicolon is required at the end of th...e line. To see available commands, use the .help command. List of Dot Commands Command Description .about Prints version, description and license informatio...uckDB CLI sends results to the terminal's standard output. However, this can be modified using either the .output or .once commands. Pass in the desired output file location as a parameter. The .once command will only output the next set of results and t... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Command Line Arguments 9776
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...MMAND Run COMMAND and exit -csv Set output mode to csv -dark-mode Use dark mode colors for syntax highlighting -echo Print commands before execution -f FILENAME Run the script in FILENAME and exit. Note that the ~/.duckdbrc is read and executed first (if...t argument cannot be combined with a local database path because the CLI acts as a client for the remote database. The SQL commands executed by -serve and -connect can be customized using the .serve_command and .connect_command dot commands , e.g., in th... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Embedding DuckDB 9397
- CLI Client The Command Line Interface (CLI) client is intended for interactive use cases and not for embedding. As a result, it has more features that could be abused by a malicious actor. For example, the CLI client has the .sh feature tha
...t allows executing arbitrary shell commands. This feature is only present in the CLI client and not in any other DuckDB clients. .sh ls Tip Calling DuckDB's CLI clien...t via shell commands is not recommended for embedding DuckDB. It is recommended to use one of the client libraries, e.g., Python , R , Java , e... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/embedding_du...
- Files Created by DuckDB 8624
- DuckDB creates several files and directories on disk. This page lists both the global and the local ones. Global Files and Directories DuckDB creates the following global files and directories in the user's home directory (denoted with ~ ):
...versions Shared between clients ~/.duckdbrc The content of this file is executed when starting the DuckDB CLI client . The commands can be both dot command and SQL statements. The naming of this file follows the ~/.bashrc and ~/.zshrc “run commands” file... - https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
- ODBC API on Linux 8393
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...tup.sh script performs the configuration of the DuckDB ODBC Driver. It is based on the unixODBC package that provides some commands to handle the ODBC setup and test like odbcinst and isql . Run the following commands with either option -u or -s to confi... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- ODBC Extension 8163
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...C can be installed using the system package manager. Depending on the Linux distribution one of the following installation commands can be used. Debian, Ubuntu: sudo apt-get install unixodbc RHEL, Alma, Rocky, Amazon, Fedora: sudo dnf install unixODBC Al...ication, connections to remote DB are expected to have auto-commit mode enabled by default. As a general rule, transaction commands BEGIN TRANSACTION / COMMIT / ROLLBACK are not supposed to be sent over ODBC as SQL commands. Doing so may or may not be su... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Catalogs 8097
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...create a token by following the create an API token steps in getting started. Then, attach the catalog with the following commands. ATTACH '⟨warehouse⟩' AS my_r2_catalog ( TYPE iceberg, URI '⟨catalog-uri⟩' ); The variables for warehouse and catalog-uri...EMA my_r2_catalog.my_schema; USE my_r2_catalog.my_schema; Apache Polaris To attach to a Polaris catalog, use the following commands: CREATE SECRET polaris_secret ( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩' ); ATTACH 'quickstart_catalo...alog_endpoint⟩', ACCESS_DELEGATION_MODE 'vended_credentials' ); Lakekeeper To attach to a Lakekeeper catalog the following commands will work. CREATE SECRET lakekeeper_secret ( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩', OAUTH2_SCOPE '... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Safe Mode 7932
- The DuckDB CLI client supports “safe mode”. Safe mode can be enabled from the command line using the -safe argument : duckdb -safe Alternatively, it can be activated during a session using the .safe_mode dot command . In safe mode, the CLI
...y connected to and prevented from interacting with the host file system. This has the following effects: The following dot commands are disabled: .cd .excel .import .log .once .open .output .read .sh .system Auto-complete no longer scans the file system... - https://man.mtool.work/duckdb/2.0/clients/cli/safe_mode.html
- Syntax Highlighting 7784
- 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
...nuation_selected brightblue If you wish to start up the CLI with a different set of colors every time, you can place these commands in the ~/.duckdbrc file that is loaded on start-up of the CLI. Error Highlighting The shell has support for highlighting c... - https://man.mtool.work/duckdb/2.0/clients/cli/syntax_highlighting.html
DuckDB 2.0 Documentation / man.mtool.work