Results of 1 - 10 of about 72 for options (0.004 sec.)
- Regular Expressions – DuckDB 13818
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...expression engine. For the regular expression syntax, see the RE2 docs . Functions All functions accept an optional set of options . Name Description regexp_extract(string, pattern[, group = 0][, options]) If string contains the regexp pattern , returns...e, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the regexp pattern , returns the capt...therwise, returns a struct with the same keys and empty strings as values. regexp_extract_all(string, regex[, group = 0][, options]) Finds non-overlapping occurrences of regex in string and returns the corresponding values of group . regexp_full_match(s... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Text Functions – DuckDB 12374
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...cter in the string . parse_dirname(path[, separator]) Returns the top-level directory name from the given path . separator options: system , both_slash (default), forward_slash , backslash . parse_dirpath(path[, separator]) Returns the head of the path...(the pathname until the last slash) similarly to Python's os.path.dirname . separator options: system , both_slash (default), forward_slash , backslash . parse_filename(string[, trim_extension][, separator]) Returns...os.path.basename function. If trim_extension is true , the file extension will be removed (defaults to false ). separator options: system , both_slash (default), forward_slash , backslash . parse_path(path[, separator]) Returns a list of the components... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- COPY Statement – DuckDB 11660
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
.../ SQL / Statements Copy Markdown COPY Statement Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv' ; Read a CSV file into the lineitem table, using manually specified CSV options: COPY l...table: COPY lineitem FROM 'lineitem.pq' ( FORMAT parquet ); Read a JSON file into the lineitem table, using auto-detected options: COPY lineitem FROM 'lineitem.json' ( FORMAT json , AUTO_DETECT true ); Read a CSV file into the lineitem table, using dou...EADER ; COPY ... TO COPY ... TO exports data from DuckDB to an external CSV or Parquet file. It has mostly the same set of options as COPY ... FROM , however, in the case of COPY ... TO the options specify how the file should be written to disk. Any fil... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Configuration – DuckDB 9431
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Format Execution Format Pivot Sitemap Live Demo Documentation / Client APIs / C Copy Markdown Configuration Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later...configuration object if ( duckdb_create_config ( & config ) == DuckDBError ) { // handle error } // set some configuration options duckdb_set_config ( config , "access_mode" , "READ_WRITE" ); // or READ_ONLY duckdb_set_config ( config , "threads" , "8"...kdb_config * config ); duckdb_create_config Initializes an empty configuration object that can be used to provide start-up options for the DuckDB instance through duckdb_open_ext . The duckdb_config must be destroyed using 'duckdb_destroy_config' This w... - https://man.mtool.work/duckdb/1.3/clients/c/config.html
- ADBC Client – DuckDB 8661
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ninitialized) database. (AdbcDatabase *database, AdbcError *error) AdbcDatabaseNew(&adbc_database, &adbc_error) DatabaseSetOption Set a char* option. (AdbcDatabase *database, const char *key, const char *value, AdbcError *error) AdbcDatabaseSetOption(&a...dbc_database, "path", "test.db", &adbc_error) DatabaseInit Finish setting options and initialize the database. (AdbcDatabase *database, AdbcError *error) AdbcDatabaseInit(&adbc_database, &adbc_error) Data...nitialized) connection. (AdbcConnection*, AdbcError*) AdbcConnectionNew(&adbc_connection, &adbc_error) ConnectionSetOption Options may be set before ConnectionInit. (AdbcConnection*, const char*, const char*, AdbcError*) AdbcConnectionSetOption(&adbc_co... - https://man.mtool.work/duckdb/1.3/clients/adbc.html
- CLI Client – DuckDB 8591
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ell environment, use the command ./duckdb instead. Usage The typical usage of the duckdb command is the following: duckdb ⟨OPTIONS⟩ ⟨FILENAME⟩ Options The OPTIONS part encodes arguments for the CLI client . Common options include: -csv : sets the output...ts the output mode to JSON -readonly : open the database in read-only mode (see concurrency in DuckDB ) For a full list of options, see the command line arguments page . In-Memory vs. Persistent Database When no FILENAME argument is provided, the DuckDB...ch will be loaded when starting the CLI client. See the Configuring the CLI section below for further information on these options. Tip To prevent the DuckDB CLI client from reading the ~/.duckdbrc file, start it as follows: duckdb -init /dev/null Below... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
- CSV Import – DuckDB 8534
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Copy Markdown CSV Import Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv' ; Use the read_csv function with custom options: SELECT * FROM read_csv ( 'flights.csv' , del...iqueCarrier' : 'VARCHAR' , 'OriginCityName' : 'VARCHAR' , 'DestCityName' : 'VARCHAR' }); Read a CSV from stdin, auto-infer options: cat flights.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( Fl...s. By default this is detected automatically from the file extension (e.g., t.csv.gz will use gzip, t.csv will use none ). Options are none , gzip , zstd . VARCHAR auto dateformat Date format used when parsing and writing dates. VARCHAR (empty) date_for... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Securing DuckDB – DuckDB 8534
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...an be problematic, especially if untrusted SQL queries are run, e.g., from public-facing user inputs. This page lists some options to restrict the potential fallout from malicious SQL queries. The approach to securing DuckDB varies depending on your use...case, environment, and potential attack models. Therefore, consider the security-related configuration options carefully, especially when working with confidential data sets. If you plan to embed DuckDB in your application, please co...read_csv , read_parquet , read_json , etc. cannot read from an external source. The allowed_directories and allowed_paths Options You can restrict DuckDB's access to certain directories or files using the allowed_directories and allowed_paths options (... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
- GDAL Integration – DuckDB 8352
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...he following query: COPY table TO 'some/file/path/filename.geojson' WITH ( FORMAT gdal , DRIVER 'GeoJSON' , LAYER_CREATION_OPTIONS 'WRITE_BBOX=YES' , SRS 'EPSG:4326' ); Available options: FORMAT : is the only required option and must be set to GDAL to u...ER : is the GDAL driver to use for the export. Use ST_Drivers() to list the names of all available drivers. LAYER_CREATION_OPTIONS : list of options to pass to the GDAL driver. See the GDAL docs for the driver you are using for a list of available optio...t supported. 関連キーワード spatial formats table available drivers driver extension geospatial vector system based export options list library read copy also through GeoJSON pass metadata Note supported Documentation 関連するページ Spatial Extension OD... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/gdal.html
- R-Tree Indexes – DuckDB 8240
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...R-tree index on the geometry column CREATE INDEX my_idx ON my_table USING RTREE ( geom ); You can also pass in additional options when creating an R-tree index using the WITH clause to control the behavior of the R-tree index. For example, to specify t...ty option: CREATE INDEX my_idx ON my_table USING RTREE ( geom ) WITH ( max_node_capacity = 16 ); The impact tweaking these options will have on performance is highly dependent on the system setup DuckDB is running on, the spatial distribution of the dat...oad. The defaults should be good enough, but you if you want to experiment with different parameters, see the full list of options here . Example Here is an example that shows how to create an R-tree index on a geometry column and where we can see that... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/r-tree_indexes.html
DuckDB 1.3 Documentation / man.mtool.work