Results of 1 - 10 of about 109 for command (0.007 sec.)
- Dot Commands 13314
- 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
...e separated, after the command. If an argument must contain a space, either single or double quotes may be used to wrap that parameter. Dot commands must...gle line, and no whitespace may occur before the period. No semicolon is required at the end of the line. To see available commands, use the .help command. List of Dot Commands Command Description .about Prints version, description, and license informat...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 files of attached databases .decimal... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Command Line Client 13135
- 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.
...tHub Actions. Please see the installation page under the CLI tab for download links. The DuckDB CLI is based on the SQLite command line shell, so CLI-client-specific functionality is similar to what is described in the SQLite documentation (although Duc...le has been downloaded, decompress it and save it to any directory. Navigate to that directory in a terminal and enter the command duckdb to run the executable. If in a PowerShell or POSIX shell environment, use the command ./duckdb instead. Usage The t...ypical usage of the duckdb command is the following: duckdb ⟨OPTIONS⟩ ⟨FILENAME⟩ Options The ⟨OPTIONS⟩ part encodes arguments for the CLI client . Common opt... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Command Line Arguments 10844
- 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
...bail Stop after hitting an error -batch Force batch I/O -box Set output mode to box -column Set output mode to column -cmd COMMAND Run COMMAND before reading stdin -connect [TYPE[:SECRET]] Connect to a remote database. The default type is quack . A name...d secret can be provided after the type -c COMMAND Run COMMAND and exit -csv Set output mode to csv -dark-mode Use dark mode colors for syntax highlighting -echo Print comma...mode to quote -readonly Open the database read-only. This option also supports attaching to remote databases via HTTPS -s COMMAND Run COMMAND and exit -safe Enable safe mode -separator SEP Set output column separator to SEP . Default: | -serve [quack[:... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- installation_content.html 8451
- DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client documentation page curl https://install
...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install....ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO... - https://man.mtool.work/duckdb/2.0/installation_content.html
- Output Formats 8388
- 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
...table tabs Tab-separated values tcl TCL list elements trash No output Changing 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...g_ducks | |----------------------| | quacking intensifies | The output appearance can also be adjusted with the .separator command. If using an export mode that relies on a separator ( csv or tabs for example), the separator will be reset when the mode...ELECT 10 AS col1, 20 AS col_2; col_1|col_2 1|2 10|20 Paging The CLI 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 p... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- DuckDB Installation 8324
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install....ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO... - https://man.mtool.work/duckdb/2.0/installation.html
- DuckDB Installation 8324
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command "irm https://install....ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO...ge docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Command " $env :DUCKDB_VERSIO... - https://man.mtool.work/duckdb/2.0/installation/
- Agent Mode 8031
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...output mode flag (such as -csv or -json ) was passed. You can also control agent mode explicitly: The -agent and -no-agent command line arguments force the mode on or off. The DUCKDB_AGENT_MODE environment variable forces the mode on ( 1 ) or off ( 0 )....The command line flags take precedence over the environment variable. To hide the startup line that announces agent mode, set .startup..._text none as the first line in ~/.duckdbrc . For example, to force agent mode on when running a single command: duckdb -agent -c "SELECT 42 AS answer;" To force it off: duckdb -no-agent -c "SELECT 42 AS answer;" Output Format In agen... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- SQL Introduction 8031
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...re listed on the PostgreSQL compatibility page . In the examples that follow, we assume that you have installed the DuckDB Command Line Interface (CLI) shell. See the installation page for information on how to install the CLI. Tip If you are looking fo...EGER, -- maximum temperature on a day prcp FLOAT, date DATE ); You can enter this into the shell with the line breaks. The command is not terminated until the semicolon. White space (i.e., spaces, tabs, and newlines) can be used freely in SQL commands....That means you can type the command aligned differently than above, or even all on one line. Two dash characters ( -- ) introduce comments. Whatever follows t... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
- PostgreSQL Extension and the Secret Manager 7420
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...db (TYPE postgres); By default, created secrets are temporary. Secrets can be persisted using the CREATE PERSISTENT SECRET command . Persistent secrets can be used across sessions. Managing Multiple Secrets Named secrets can be used to manage connection...generate the password, that is refreshed by the postgres extension automatically. Connecting with IAM Authentication from Command Line This section illustrates the process with psql utility, not with DuckDB. This method can be used to check the configu...ration before setting up DuckDB secrets. When IAM authentication is performed using psql command line tool, the following are the AWS-recommended connection steps: Generate authentication token using aws CLI. Pass this... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
DuckDB 2.0 Documentation / man.mtool.work