Results of 1 - 10 of about 34 for pragma (0.001 sec.)
- Pragmas 15737
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...retrieve a setting's value using SELECT current_setting('option_name') . Deprecated Assigning configuration settings with PRAGMA name = value is deprecated and emits a warning. Use SET name = value instead. The warning becomes an error when warnings_a...s_errors is enabled. Function-style PRAGMA calls (for example, PRAGMA table_info('table_name') ) and the SQLite-compatible PRAGMA table_info = 'table_name' form are...guration options. These are documented 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... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- DuckDB Environment 10273
- 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 v
...2.0.0 Using a PRAGMA : PRAGMA version; library_version source_id codename v2.0.0 d54cbbe3df Cyanoptera Platform The platform information consis...d, optionally, the compiler. The platform is used when installing extensions . To retrieve the platform, use the following PRAGMA : PRAGMA platform; On macOS, running on Apple Silicon architecture, the result is: platform osx_arm64 On Windows, running... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- Parquet Encryption 9906
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...t_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'); PRAGMA add_pa...rquet_key('key256', '01234567891123450123456789112345'); PRAGMA add_parquet_key('key256base64', 'MDEyMzQ1Njc4OTExMjM0NTAxMjM0NTY3ODkxMTIzNDU='); Writing Encrypted Parquet Files After spe... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- SQL to/from JSON 9298
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...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...hough with the limitation that the serialized JSON must be provided as a constant string, i.e., you cannot do PRAGMA json_execute_serialized_sql(json_serialize_sql(...)) . Note that these functions do not preserve syntactic sugar such as F... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Full-Text Search Extension 9107
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...itory. If you would like to install and load it manually, run: INSTALL AND 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', ignore...= '(\\.|[^a-z])+', strip_accents = 1, lower = 1, overwrite = 0, incremental = 0) PRAGMA that creates a FTS index for the specified table. Name Type Description input_table VARCHAR Qualified name of specified ta... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Collations 8803
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
...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...is extension will add a number of language and region specific collations to your database. These can be queried using the PRAGMA collations command, or by querying the pragma_collations function. PRAGMA collations; SELECT list(collname) FROM pragma_co... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
- CALL Statement 8691
- The CALL statement invokes the given table function and returns the results. Thanks to the FROM -first syntax and the fact that procedures in DuckDB are implemented as table functions, you can use FROM instead of CALL . 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_ : SEL... - https://man.mtool.work/duckdb/2.0/sql/statements/call.html
- Profile and Monitor 8563
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...enabled on a connection before metrics are collected. Enable it with the enable_profiling PRAGMA , run a query, then read the result with get_profiling_info() : use duckdb::Connection; let conn = Connection::open_in_mem...ory()?; // Do not print profiling output to stdout after each query (the default when profiling is enabled). conn.execute("PRAGMA enable_profiling = 'no_output'", [])?; conn.execute("SELECT 42", [])?; let info = conn.get_profiling_info().expect("profil...pped, calling interrupt() is a no-op. Further Reading Profiling — DuckDB's query profiling output and the enable_profiling PRAGMA and the tracked_metrics setting. Run Queries — running the queries whose metrics this page reads and whose execution it in... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- sqllogictest Introduction 8084
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...low: # name: test/sql/projection/test_simple_projection.test # group [projection] # enable query verification statement ok PRAGMA enable_verification # create table statement ok CREATE TABLE a (i INTEGER, j INTEGER); # insertion: 1 affected row stateme...f tests. Query Verification Many simple tests start by enabling query verification. This can be done through the following PRAGMA statement: statement ok PRAGMA enable_verification Query verification performs extra validation to ensure that the underly... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- DROP Statement 7956
- The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI
...a 1 GB table, the file might still be 2 GB, but it should have 1 GB of free blocks in it. To check this, use the following PRAGMA and check the number of free_blocks in the output: PRAGMA database_size; For instructions on reclaiming space after droppi... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
DuckDB 2.0 Documentation / man.mtool.work