Results of 1 - 4 of about 4 for getenv (0.001 sec.)
- Command Line Client 12371
- 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.
....open --readonly preexisting.duckdb The --sql option allows setting the database path using a SQL expression: .open --sql "getenv('MY_DB_PATH')" Output Formats The .mode dot command may be used to change the appearance of the tables returned in the ter...CT * FROM read_csv('/dev/stdin')) TO '/dev/stdout' WITH (FORMAT csv, HEADER)" 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 of the getenv function can be used to set configuration options . For ex... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Safe Mode 8746
- 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
....output .read .sh .system Auto-complete no longer scans the file system for files to suggest as auto-complete targets. The getenv function is disabled. The enable_external_access option is set to false . This implies that: ATTACH cannot attach to a dat... - https://man.mtool.work/duckdb/2.0/clients/cli/safe_mode.html
- Utility Functions 8025
- 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
...with the given name. get_type(expression) Returns the data type of the result of the expression as a value of type TYPE . getenv(var) Returns the value of the environment variable var . Only available in the command line client . getvariable('variable...ata type of the result of the expression as a value of type TYPE . | | Example | get_type([1, 2]) | | Result | INTEGER[] | getenv(var) | Description | Returns the value of the environment variable var . Only available in the command line client . | | E...xample | getenv('HOME') | | Result | /path/to/user/home | getvariable('variable_name') | Description | Returns the value of the SQL variab... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- ATTACH and DETACH Statements 7785
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...'; ATTACH 'account_' || getvariable('account_id') || '.db' AS account_db; Read the path from an environment variable using getenv() , which is available in the CLI client only: ATTACH getenv('DATABASE_PATH') AS env_db; The path expression must not eval... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work