Results of 1 - 10 of about 370 for Keywords (0.004 sec.)
- Keywords and Identifiers – DuckDB 15691
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...rage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / DuckDB's SQL Dialect Copy Markdown Keywords and Identifiers Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are sub...several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keywords() ), e.g., SELECT 123 AS SELECT will fail. They must not start with a number or special character, e.g., SELECT 123 AS 1co... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- DuckDB Environment – DuckDB 11392
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...etween objects duckdb_extensions() : extensions duckdb_functions() : functions duckdb_indexes() : secondary indexes duckdb_keywords() : DuckDB's keywords and reserved words duckdb_optimizers() : the available optimization rules in the DuckDB instance duc...e Meta number retrieve information instance following available objects columns constraints databases dependencies indexes keywords schemas sequences settings tables 関連するページ Extensions Extension Distribution Advanced Installation Methods Files Cre... - https://man.mtool.work/duckdb/1.3/guides/meta/duckdb_environment.html
- Dot Commands – DuckDB 8079
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...data from FILE into TABLE .indexes TABLE Show names of indexes .keyword COLOR Sets the syntax highlighting color used for keywords .keywordcode CODE Sets the syntax highlighting terminal code used for keywords .large_number_rendering all/footer/off Togg...yan|brightwhite] .constantcode ⟨terminal_code⟩ For example: .constantcode 033[31m To configure the color used to highlight keywords: .keyword [red|green|yellow|blue|magenta|cyan|white|brightblack|brightred|brightgreen|brightyellow|brightblue|brightmagent... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- DuckDB_% Metadata Functions – DuckDB 7744
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...IQUE constraints are maintained using indexes, but their details are included in the duckdb_constraints() function. duckdb_keywords The duckdb_keywords() function provides metadata about DuckDB's keywords and reserved words. Column Description Type keywo...b_columns duckdb_constraints duckdb_databases duckdb_dependencies duckdb_extensions duckdb_functions duckdb_indexes duckdb_keywords duckdb_log_contexts duckdb_logs duckdb_memory duckdb_optimizers duckdb_prepared_statements duckdb_schemas duckdb_secret_ty... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Autocomplete – DuckDB 7083
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...b to cycle backwards. autocompletion can be reverted by pressing ESC twice. The shell autocompletes four different groups: Keywords Table names and table functions Column names and scalar functions File names The shell looks at the position in the SQL st... - https://man.mtool.work/duckdb/1.3/clients/cli/autocomplete.html
- Syntax Highlighting – DuckDB 6757
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...ntirely using the .highlight off command. Below is a list of components that can be configured. Type Command Default color Keywords .keyword green Constants ad literals .constant yellow Comments .comment brightblack Errors .error red Continuation .cont b... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- Interval Type – DuckDB 5762
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...ported; stored as (48 * 60 * 60 * 1e6 microseconds) ; Warning Decimal values are truncated to integers when used with unit keywords (unless the unit is SECONDS or MILLISECONDS ). SELECT INTERVAL '1.5' YEARS ; -- Returns 12 months; equivalent to `to_years... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- PostgreSQL Compatibility – DuckDB 5762
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...vedCase matching regexp myschema Expression performs successfully insensitive exist tables statement mytype 関連するページ Keywords and Identifiers PostgreSQL Import SQL Quirks DROP Statement PostgreSQL Extension List Tables See this page as Markdown Edi... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Pattern Matching – DuckDB 5762
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...LIKE with ESCAPE: SELECT 'A%c' ILIKE 'a$%c' ESCAPE '$' ; -- true There are also alternative characters that can be used as keywords in place of LIKE expressions. These enhance PostgreSQL compatibility. PostgreSQL-style LIKE -style ~~ LIKE !~~ NOT LIKE ~~... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- CSV Import – DuckDB 5101
- 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
...Constraints Indexes Meta Queries Information Schema Metadata Functions DuckDB's SQL Dialect Overview Indexing Friendly SQL Keywords and Identifiers Order Preservation PostgreSQL Compatibility SQL Quirks Samples Configuration Overview Pragmas Secrets Mana...e_names Normalize column names. This removes any non-alphanumeric characters from them. Column names that are reserved SQL keywords are prefixed with an underscore character ( _ ). BOOL false null_padding Pad the remaining columns on the right with NULL... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
DuckDB 1.3 Documentation / man.mtool.work