Results of 1 - 10 of about 370 for information (0.004 sec.)
- Pragmas – DuckDB 14643
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...ented in the respective extensions' documentation pages. This page contains the supported PRAGMA settings. Metadata Schema Information List all databases: PRAGMA database_list ; List all tables: PRAGMA show_tables ; List all tables, with extra information,...mber of schemas DuckDB looks through, use the catalog_error_max_schemas option: SET catalog_error_max_schemas = 10 ; Table Information Get info for a specific table: PRAGMA table_info ( 'table_name' ); CALL pragma_table_info ( 'table_name' ); table_info ret... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Reading Faulty CSV Files – DuckDB 9497
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...r will immediately stop the scanning process and throw the error to the user. These errors are designed to provide as much information as possible to allow users to evaluate them directly in their CSV file. This is an example for a full error message: Conve...rmat = (Auto-Detected) null_padding=0 sample_size=20480 ignore_errors=false all_varchar=0 The first block provides us with information regarding where the error occurred, including the line number, the original CSV line, and which field was problematic: Con... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- DuckDB_% Metadata Functions – DuckDB 9180
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...maximum number of fractional digits (i.e., the number of digits that may appear after the decimal separator). INTEGER The information_schema.columns system view provides a more standardized way to obtain metadata about database columns, but the duckdb_colu...mns function also returns metadata about DuckDB internal objects. (In fact, information_schema.columns is implemented as a query on top of duckdb_columns() ) duckdb_constraints The duckdb_constraints() function... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Information Schema – DuckDB 8660
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...view Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Meta Queries Copy Markdown Information Schema 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's information schema . Tables character_s... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 8132
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...obal context in which to access data. Use case Initializing ODBC, managing driver behavior, resource allocation Additional information Must be allocated once per application upon starting, and freed at the end. Connection Handle name Connection Type name SQ...ource to use within the driver. Use case Establishing a connection to a database, managing the connection state Additional information Multiple connection handles can be created as needed, allowing simultaneous connections to multiple data sources. Note: Al... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
- PostgreSQL Extension – DuckDB 7823
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...name current user An example URI is postgresql://username@hostname/dbname . Configuring via Secrets PostgreSQL connection information can also be specified with secrets . The following syntax can be used to create a secret. CREATE SECRET ( TYPE postgres ,...HOST '127.0.0.1' , PORT 5432 , DATABASE postgres , USER 'postgres' , PASSWORD '' ); The information from the secret will be used when ATTACH is called. We can leave the PostgreSQL connection string empty to use all of the... - https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html
- Logging – DuckDB 7612
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...ocumentation / Operations Manual / Logging Copy Markdown Logging DuckDB contains a logging mechanism to provide additional information to users, such as query execution details, performance metrics, and system events. Basics DuckDB's logging mechanism can b...at control the verbosity of the logs: ERROR : Only logs error messages WARN : Logs warnings and errors INFO : Logs general information, warnings and errors (default) DEBUG : Logs detailed debugging information TRACE : Logs very detailed tracing information... - https://man.mtool.work/duckdb/1.3/operations_manual/logging/overview.html
- MySQL Extension – DuckDB 7506
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...set of key=value pairs. Any options not provided are replaced by their default values, as per the table below. Connection information can also be specified with environment variables . If no option is provided explicitly, the MySQL extension tries to read..._mode preferred ssl_ca ssl_capath ssl_cert ssl_cipher ssl_crl ssl_crlpath ssl_key Configuring via Secrets MySQL connection information can also be specified with secrets . The following syntax can be used to create a secret. CREATE SECRET ( TYPE mysql , HOS... - https://man.mtool.work/duckdb/1.3/core_extensions/mysql.html
- Building Configuration – DuckDB 7189
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...pped of all the assertions and debug symbols and code, optimized for performance. debug This build runs with all the debug information, including symbols, assertions and #ifdef DEBUG blocks. Due to these, binaries of this build are expected to be slow. Note...fdef DEBUG code blocks but it still has debug symbols that make it possible to step through the execution with line number information and D_ASSERT lines are still checked in this build. Binaries of this build mode are significantly faster than those of the... - https://man.mtool.work/duckdb/1.3/dev/building/build_configuration.html
- DuckLake – DuckDB 6977
- 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
...ons Timestamp with Time Zone Functions Union Functions Utility Functions Window Functions Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation...ed 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...ME ZONE schema_version BIGINT changes MAP(VARCHAR, VARCHAR[]) 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 cat... - https://man.mtool.work/duckdb/1.3/core_extensions/ducklake.html
DuckDB 1.3 Documentation / man.mtool.work