Results of 1 - 10 of about 30 for pragma (0.003 sec.)
- Pragmas – DuckDB 16034
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...Overview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / Configuration Copy Markdown Pragmas The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manne...r to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the subsequent execution or behavior of th... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- Full-Text Search Extension – DuckDB 9487
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...repository. If you would like to install and load it manually, run: INSTALL fts ; LOAD fts ; Usage The extension adds two PRAGMA statements to DuckDB: one to create, and one to drop an index. Additionally, a scalar macro stem is added, which is used i...nternally by the extension. PRAGMA create_fts_index create_fts_index ( input_table , input_id , * input_values , stemmer = 'porter' , stopwords = 'english' ,... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- SQL to/from JSON – DuckDB 9179
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...Scalar Serialize a set of semicolon-separated ( ; ) select statements to an equivalent list of json serialized statements. PRAGMA json_execute_serialized_sql(varchar) Pragma Pragma version of the json_execute_serialized_sql function. The json_serialize...ee any transaction local changes. This is because the statements are executed in a separate query context. You can use the PRAGMA json_execute_serialized_sql(varchar) pragma version to execute the statements in the same query context as the pragma, alt... - https://man.mtool.work/duckdb/1.3/data/json/sql_to_and_from_json.html
- DuckDB Environment – DuckDB 9065
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...Live Demo Documentation / Guides / Meta Queries Copy Markdown DuckDB Environment DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns...the version number of DuckDB. SELECT version () AS version ; version v1.5.6 Using a PRAGMA : PRAGMA version ; library_version source_id v1.5.6 069cc9f9b5 Platform The platform information consists of the operating... - https://man.mtool.work/duckdb/1.3/guides/meta/duckdb_environment.html
- Logging – DuckDB 9000
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...cution details, performance metrics, and system events. Basics DuckDB's logging mechanism can be enabled or disabled using pragmas. By default, logs are stored in a special table called duckdb_logs that can be queried like any other table. Example: PRA...DEBUG : Logs detailed debugging information TRACE : Logs very detailed tracing information The log level can be set using: PRAGMA enable_logging ; SET logging_level = 'TRACE' ; Log Types In DuckDB, log messages can have an associated log type. Log type... - https://man.mtool.work/duckdb/1.3/operations_manual/logging/overview.html
- Parquet Encryption – DuckDB 8935
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_parquet_key function, named encryption keys of 128, 192, or 256 bits can be added to a session. These keys are stored...in-memory: PRAGMA add_parquet_key ( 'key128' , '0123456789112345' ); PRAGMA add_parquet_key ( 'key192' , '012345678911234501234567' ); PRAGM... - https://man.mtool.work/duckdb/1.3/data/parquet/encryption.html
- Collations – DuckDB 8577
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...on . It is also possible to specify a default collator, either on the global database level or on a base table column. The PRAGMA default_collation can be used to specify the global default collator. This is the collator that will be used if no other o...g this extension will add a number of language and region specific collations to your database. These can be queried using PRAGMA collations command, or by querying the pragma_collations function. PRAGMA collations ; SELECT list ( collname ) FROM pragm... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- Profiling – DuckDB 8334
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...h treeflex json – produces a JSON output To specify a format, use the FORMAT tag: EXPLAIN ( FORMAT html ) SELECT 42 AS x ; Pragmas DuckDB supports several pragmas for turning profiling on and off and controlling the level of detail in the profiling out...put. The following pragmas are available and can be set using either PRAGMA or SET . They can also be reset using RESET , followed by the setting na... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- CALL Statement – DuckDB 8334
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...tion and returns the results. Examples Invoke the 'duckdb_functions' table function: CALL duckdb_functions (); Invoke the 'pragma_table_info' table function: CALL pragma_table_info ( 'pg_am' ); Select only the functions where the name starts with ST_ :...return_type FROM duckdb_functions () WHERE function_name LIKE 'ST_%' ; Syntax 関連キーワード table functions duckdb Invoke pragma info Documentation Statements Copy Markdown Statement statement invokes given results Examples starts parameters parameter... - https://man.mtool.work/duckdb/1.3/sql/statements/call.html
- EXPLAIN: Inspect Query Plans – DuckDB 8090
- 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
...riendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Manager Extensions Overview Installing Extensions Advanced Installation Methods Distributing Extensions Versionin...an be used to control the output. The following settings are available: The default setting. Only shows the physical plan. PRAGMA explain_output = 'physical_only' ; Shows only the optimized plan. PRAGMA explain_output = 'optimized_only' ; Shows both th...e physical and optimized plans. PRAGMA explain_output = 'all' ; See Also For more information, see the ”Profiling” page . 関連キーワード ││ physical plan query s... - https://man.mtool.work/duckdb/1.3/guides/meta/explain.html
DuckDB 1.3 Documentation / man.mtool.work