Results of 1 - 10 of about 166 for varchar (0.006 sec.)
- DuckDB_% Metadata Functions 10108
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
....g., using the tracked_metrics setting. Column Description Type metric_name The name of the metric, e.g., query.cpu_time . VARCHAR metric_type The type of the metric's value, e.g., double , uint64 , string or map . VARCHAR description Human readable tex...t that describes the metric. VARCHAR unit The unit of the metric, e.g., seconds or rows . Empty for unitless metrics. VARCHAR duckdb_columns The duckdb_columns...le in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VARCHAR database_oid Internal identifier of the database that contains the column object. BIGINT schema_name The SQL name of the s... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Information Schema 9722
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...cter_sets : Character Sets Column Description Type Example character_set_catalog Currently not implemented – always NULL . VARCHAR NULL character_set_schema Currently not implemented – always NULL . VARCHAR NULL character_set_name Name of the character...set, currently implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_repertoire Character repertoire, showing UCS if the encoding is UTF8 , else just the encoding name. VARCH...AR 'UCS' form_of_use Character encoding form, same as the database encoding. VARCHAR 'UTF8' default_collate_catalog Name of the database containing the default collation (always the current database). VARCHA... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Configuration 9200
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...iguration options by scope. Global Configuration Options Name Description Type Default value Calendar The current calendar VARCHAR System (locale) calendar TimeZone The current time zone VARCHAR System (locale) timezone access_mode Access mode of the da...tabase ( AUTOMATIC , READ_ONLY or READ_WRITE ). VARCHAR automatic allocator_background_threads Whether to enable the allocator background threads. BOOLEAN false allocator_bulk_de...allocation_flush_threshold If a bulk deallocation larger than this occurs, flush outstanding allocations. VARCHAR 512.0 MiB allocator_flush_threshold Peak allocation threshold at which to flush the allocator after completing a task. VAR... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- ODBC Extension Functions 8620
- 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) ->
...tails. Parameters: conn_handle ( BIGINT ): ODBC connection handle created with odbc_connect Returns: Always returns NULL ( VARCHAR ). Example: SELECT odbc_begin_transaction(getvariable('conn')) odbc_bind_params odbc_bind_params(conn_handle BIGINT, param...odbc_bind_params(getvariable('conn'), getvariable('params1'), row(42, 'foo')) odbc_close odbc_close(conn_handle BIGINT) -> VARCHAR Closes specified ODBC connection to a remote DB. Does not throw errors if the connection is already closed. Parameters: co...nn_handle ( BIGINT ): ODBC connection handle created with odbc_connect Returns: Always returns NULL ( VARCHAR ). Example: SELECT odbc_close(getvariable('conn')) odbc_commit odbc_commit(conn_handle BIGINT) -> VARCHAR Calls SQLEndTran... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- CSV Import 8620
- 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', delim = '|', header =
...true, columns = { 'FlightDate': 'DATE', 'UniqueCarrier': 'VARCHAR', 'OriginCityName': 'VARCHAR', 'DestCityName': 'VARCHAR' }); Read a CSV from stdin, auto-infer options: cat flights.csv |..."SELECT * FROM read_csv('/dev/stdin')" Read a CSV file into a table: CREATE TABLE ontime ( FlightDate DATE, UniqueCarrier VARCHAR, OriginCityName VARCHAR, DestCityName VARCHAR ); COPY ontime FROM 'flights.csv'; Alternatively, create a table without spe...ere meaningfully applicable, these parameters can also be passed to the COPY statement . Name Description Type Default all_varchar Skip type detection and assume all columns are of type VARCHAR . This option is only supported by the read_csv function. B... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- Python Client API 8575
- 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
...expression as the string. SPEC : ClassVar [ dict [ str , tuple [ str , int , list [ str ] ] ] ] = {'ascii': ('ascii', 0, ['VARCHAR']), 'bin': ('bin', 0, ['VARCHAR']), 'bit_length': ('bit_length', 0, ['VARCHAR']), 'concat_ws': ('concat_ws', 1, ['VARCHAR'..., 'ANY']), 'contains': ('contains', 0, ['VARCHAR', 'VARCHAR']), 'damerau_levenshtein': ('damerau_levenshtein', 0, ['VARCHAR', 'VARCHAR']), 'format': ('format', 0, ['VARCHA...R']), 'from_base64': ('from_base64', 0, ['VARCHAR']), 'hamming': ('hamming', 0, ['VARCHAR', 'VARCHAR']), 'ilike_escape': ('ilike_escape', 0, ['VARCHAR', 'VARCHAR', 'VARCHAR... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- DuckLake 8518
- 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
...schema_version │ changes │ author │ commit_message │ commit_extra_info │ │ int64 │ timestamp with time zone │ int64 │ map(varchar, varchar[]) │ varchar │ varchar │ varchar │ ├─────────────┼────────────────────────────┼────────────────┼─────────────────...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 Column type snapshot_id BIGINT snapshot_...time TIMESTAMP WITH TIME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message VARCHAR commit_extra_info VARCHAR ducklake_table_info The ducklake_table_info fu... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- Querying Parquet Metadata 8382
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...OM parquet_metadata('data/*.parquet'); Below is a table of the columns returned by parquet_metadata . Field Type file_name VARCHAR row_group_id BIGINT row_group_num_rows BIGINT row_group_num_columns BIGINT row_group_bytes BIGINT column_id BIGINT file_of...fset BIGINT num_values BIGINT path_in_schema VARCHAR type VARCHAR stats_min VARCHAR stats_max VARCHAR stats_null_count BIGINT stats_distinct_count BIGINT stats_min_value VARCH...AR stats_max_value VARCHAR compression VARCHAR encodings VARCHAR index_page_offset BIGINT dictionary_page_offset BIGINT data_page_offset BIGINT total... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Relational API 8348
- The Relational API builds a query one step at a time from Python. A relation, a DuckDBPyRelation , is a piece of SQL text: the methods of the Transformation and Functions sections return a new relation whose text extends the one they were c
...= duckdb.connect() rel = duckdb_conn.from_arrow(example_table) rel.show() Result ┌──────┬─────────┐ │ id │ text │ │ int8 │ varchar │ ├──────┼─────────┤ │ 1 │ a │ └──────┴─────────┘ from_csv_auto from_csv_auto(self: _duckdb.DuckDBPyConnection, *args: obj...duckdb_conn = duckdb.connect() rel = duckdb_conn.from_df(df) rel.show() Result ┌───────┬─────────┐ │ id │ text │ │ int64 │ varchar │ ├───────┼─────────┤ │ 1 │ a │ └───────┴─────────┘ from_parquet from_parquet(self: _duckdb.DuckDBPyConnection, path_or_bu...: bool, keyword-only, default: None Whether to detect the dialect, the header and the types. Detected when omitted. * all_varchar : bool, keyword-only, default: None Read every column as VARCHAR , without detecting the types. * normalize_names : bool,... - https://man.mtool.work/duckdb/2.0/clients/python/relational_api.html
- PostgreSQL Extension Functions 8189
- 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
...rrent effective configuration options and the collected runtime statistics of a connection pool. Parameters catalog_name ( VARCHAR ): the name (alias) of the attached Postgres database to which pool the configuration change is applied and details are re...gs without changing their configuration. Must be specified and non-NULL when any other option is specified. acquire_mode ( VARCHAR , default: 'force' ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit), 'wait' (block...fetime_millis or idle_timeout_millis must be set to a non-zero value for this option to be effective. health_check_query ( VARCHAR ): the query that is used to check that the connection is healthy. Setting this option to an empty string disables the hea... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
DuckDB 2.0 Documentation / man.mtool.work