⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 10 of about 12 for home (0.002 sec.)
Command Line Client 13053
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. ... oint to a different initialization file using the -init flag. Warning The CLI reads and writes several files in the user's home directory, including ~/.duckdbrc , ~/.duckdb_history , and the extension directory ~/.duckdb/extensions . If the home dire ... tup can fail with an error such as IO Error: Failed to create directory . In sandboxed or restricted environments, set the HOME environment variable to a writable location to control where these files are created. See Files Created by DuckDB for the ... ER)" woot 42 43 Reading Environment Variables The getenv function can read environment variables. Examples To retrieve the home directory's path from the HOME environment variable, use: SELECT getenv('HOME') AS home; home /Users/user_name The output ...
https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
ODBC API on Linux 11444
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 ... nd isql . Run the following commands with either option -u or -s to configure DuckDB ODBC. The -u option based on the user home directory to setup the ODBC init files. batch ./unixodbc_setup.sh -u The -s option changes the system level files that wil ... ctory ``` The ODBC setup on Linux is based on the .odbc.ini and .odbcinst.ini files. These files can be placed to the user home directory /home/⟨username⟩ or in the system /etc directory. The Driver Manager prioritizes the user configuration files ov ...
https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
Unit Tester Configuration 9852
There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line ... ersistent storage file --init-script <path> SQL script to execute on init --initial-db <path> Initial database path --keep-home Use $HOME/USERPROFILE instead of the sandboxed temp-dir home --max-test-threads <num> Max threads to be used by the test r ...
https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
Installing Extensions 9852
To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo ... ent API, refer to the Client API documentation Installation Location By default, extensions are installed under the user's home directory: ~/.duckdb/extensions/⟨duckdb_version⟩/⟨platform_name⟩/ For stable DuckDB releases, the ⟨duckdb_version⟩ will be ... ng when set. It will be removed in a future release. Use extension_directories instead. Note that setting the value of the home_directory configuration option has no effect on the location of the extensions. Uninstalling Extensions Currently, DuckDB ... LI client on macOS, it is available from the Python, R, etc. client libraries provided that they have access to the user's home directory and use DuckDB version 1.2.1. Limitations DuckDB's extension mechanism has the following limitations: Extensions ...
https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
ODBC Configuration 8242
This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific ...
https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
Files Created by DuckDB 8242
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 ~ ): ...
https://man.mtool.work/duckdb/2.0/operations_manual/footprint_of_duckdb/files_cr...
Editing 7888
The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo ... hen on the first line, move to previous history entry Down Move down a line. When on last line, move to next history entry Home Move to beginning of buffer End Move to end of buffer Ctrl + Left Move back a word Ctrl + Right Move forward a word Ctrl + ...
https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
Quack on WebAssembly 7888
CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th ... ined at https://github.com/duckdb/duckdb-quack-infra Deploy via Web UI Visit https://console.aws.amazon.com/cloudformation/home#/stacks/quickcreate?templateURL=https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml&stackName=my-duckdb-quack-d ...
https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
Secrets Manager 7535
The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in ... a new DuckDB instance before creating or using persistent secrets from that directory. Note that setting the value of the home_directory configuration option has no effect on the location of the secrets. Connection-Scoped Secrets New As of DuckDB 2. ...
https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
Utility Functions 7535
Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet ... on | Returns the value of the environment variable var . Only available in the command line client . | | Example | getenv('HOME') | | Result | /path/to/user/home | getvariable('variable_name') | Description | Returns the value of the SQL variable nam ...
https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
PREV 1 2 NEXT
DuckDB 2.0 Documentation / man.mtool.work