Results of 1 - 10 of about 77 for named (0.009 sec.)
- DuckLake 12957
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...ATA_PATH 'data_files'); USE my_ducklake; Tables In DuckDB, the ducklake extension stores the catalog tables for a DuckLake named my_ducklake in the __ducklake_metadata_⟨my_ducklake⟩ catalog. Functions Note that DuckLake registers several functions. Th...────┘ ducklake_snapshots Returns the snapshots stored in the DuckLake catalog name catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Co...CHAR ducklake_table_info The ducklake_table_info function returns information on the tables stored in the DuckLake catalog named catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a t... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- ODBC Extension Functions 10968
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...t('Driver={Oracle Driver};DBQ=//127.0.0.1:1521/XE', 'scott', 'tiger') odbc_copy odbc_copy(conn_handle BIGINT, [, <optional named parameters>]) -> TABLE odbc_copy(conn_string VARCHAR, [, <optional named parameters>]) -> TABLE Copies rows from a DuckDB...ies, in this case new ODBC connection will be opened and will be closed automatically after the query is complete Optional named parameters (source): Source query is executed using a separate DB instance from the instance on which odbc_copy is being c...T <limit> OFFSET <offset> to it, must be more or equal to 2048 , 2048 must be dividable by it without a remainder Optional named parameters (destination): dest_table ( VARCHAR ): destination table name in remote DB, will be used in INSERT and CREATE T... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Prepared Statements 10774
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...statements: auto-incremented ( ? ), positional ( $1 ), and named ( $param ). Note that not all clients support all of these syntaxes, e.g., the JDBC client only supports auto-incremented...as follows. Note that the first parameter corresponds to $1 , the second to $2 , and so on. EXECUTE query_person(40, 'B'); Named Parameters: $parameter DuckDB also supports named parameters where parameters are denoted with $parameter_name . For examp...t_letter := 'B', minimum_age := 40); Session Variables as Default Values New Using session variables as default values for named parameters was introduced in DuckDB 2.0. When a named parameter is not supplied at execution time, DuckDB fills it from th... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- PREPARE, EXECUTE, and DEALLOCATE Statements 9973
- The PREPARE statement creates a prepared statement for later execution. The EXECUTE statement runs it with optional arguments. The DEALLOCATE statement removes it. For details about auto-incremented, positional, and named parameters, see Pr
...epared Statements . PREPARE Prepare a statement named query_person : PREPARE query_person AS SELECT * FROM person WHERE starts_with(name, $name_start) AND age >= $minimum_age;...Syntax EXECUTE Execute a prepared statement with named arguments: EXECUTE query_person(name_start := 'B', minimum_age := 40); Execute a prepared statement with positional argume... - https://man.mtool.work/duckdb/2.0/sql/statements/prepare.html
- Table Functions 9379
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...function_add_parameter ( duckdb_table_function table_function , duckdb_logical_type type ); void duckdb_table_function_add_named_parameter ( duckdb_table_function table_function , const char * name , duckdb_logical_type type ); void duckdb_table_funct..._info info ); duckdb_value duckdb_bind_get_parameter ( duckdb_bind_info info , idx_t index ); duckdb_value duckdb_bind_get_named_parameter ( duckdb_bind_info info , const char * name ); void duckdb_bind_set_bind_data ( duckdb_bind_info info , void * b...rameters table_function : The table function. type : The parameter type. Cannot contain INVALID. duckdb_table_function_add_named_parameter Adds a named parameter to the table function. Syntax void duckdb_table_function_add_named_parameter ( duckdb_tab... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- PostgreSQL Extension Functions 9379
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...alue is not available. Example CALL postgres_clear_cache() postgres_configure_pool FROM postgres_configure_pool([⟨optional named parameters⟩]) -> TABLE When a PostgreSQL database is attached, a connection pool is created for this database. This functi...= 'wait', max_connections = 42) postgres_execute postgres_execute(attached_db_name VARCHAR, sql_query VARCHAR[, ⟨optional named parameters⟩]) -> TABLE Executes the ⟨sql_query⟩ in the specified remote Postgres instance previously attached with ATTACH...ry that is passed to PostgreSQL for execution; no transformation or analysis of this query is performed by DuckDB Optional named parameters: use_transaction ( BOOLEAN , default: TRUE ): whether to start a PostgreSQL transaction if it was not started b... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Struct Functions 9186
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unnamed
...ctions that work with entry names, i.e., struct_insert , struct_keys , struct_update and remap_struct , require a STRUCT . Name Description struct.entry Dot notation that serves as an alias for struct_extract from named STRUCT s. struct[entry] Bracket...notation that serves as an alias for struct_extract from named STRUCT s. struct[idx] Bracket notation that serves as an alias for struct_extract from TUPLE s, using an index (1-based)....ruct_contains(struct, entry) Check if the STRUCT contains the specified entry. struct_extract(struct, 'entry') Extract the named entry from the STRUCT . struct_extract(struct, idx) Extract the entry from a TUPLE using an index (1-based). struct_extrac... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Python Client API 9089
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...le_name : str , df : object , * , by_name : bool = False ) → _duckdb.DuckDBPyConnection Append the passed DataFrame to the named table appender ( self , table : str , * , columns : list | None = None , action : str = 'insert' , key : list | None = Non...e ) → _duckdb.Appender Create an appender that buffers rows and inserts, upserts, updates or deletes them in the named table at each flush array_type ( self , type : _duckdb._sqltypes.DuckDBPyType , size : int ) → _duckdb._sqltypes.DuckDBPyT...e Create a struct type object from ‘fields' table ( table_name : str ) → DuckDBPyRelation Create a relation object for the named table. table_function ( name : str , parameters : object = None ) → DuckDBPyRelation Create a relation object from the nam... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- CREATE MACRO Statement 9089
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...Positional parameter passing means that only the value expression is passed; In contrast to positional parameter passing, named parameter passing explicitly assigns the actual parameter value to a specific formal parameter. This is done by mentioning...d by the assignment operator := , followed by the parameter value expression. Note that some built-in functions also allow named parameters, but allow = as assignment operator. For macros, this won't work! Instead, the = is interpreted as comparison o...perator. This effectively turns the - intended - named parameter into a positional parameter passing the result of comparing the parameter name with the parameter value expressi... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Command Line Arguments 8495
- 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
...MAND Run COMMAND before reading stdin -connect [TYPE[:SECRET]] Connect to a remote database. The default type is quack . A named secret can be provided after the type -c COMMAND Run COMMAND and exit -csv Set output mode to csv -dark-mode Use dark mode...rator SEP Set output column separator to SEP . Default: | -serve [quack[:SECRET]] Serve the opened database with Quack . A named secret can be provided after the type -storage-version VER Database storage compatibility version to use. To use the lates...t on the same machine works without further setup: duckdb -connect Both arguments accept a connection type and an optional named secret in the form TYPE:SECRET . Only the quack type can be served. For example, after creating a persistent Quack secret... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
DuckDB 2.0 Documentation / man.mtool.work