Results of 1 - 10 of about 15 for quotes (0.004 sec.)
- Literal Types – DuckDB 14437
- 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
...ECT 1_2.1_2E0_1 ; -- 121.2 SELECT '0b0_1_0_1' :: INTEGER ; -- 5 String Literals String literals are delimited using single quotes ( ' , apostrophe) and result in STRING_LITERAL values. Note that double quotes ( " ) cannot be used as string delimiter ch...aracter: instead, double quotes are used to delimit quoted identifiers . Implicit String Literal Concatenation Consecutive single-quoted string literals s...use of regular double-dollar symbols within the string literal: SELECT $ tag $ this string can contain newlines , 'single quotes' , "double quotes" , and $$ dollar quotes $$ $ tag $ AS msg ; ┌───────────────────────────────────────────────────────────... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- COPY Statement – DuckDB 10623
- 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
...PY lineitem FROM 'lineitem.json' ( FORMAT json , AUTO_DETECT true ); Read a CSV file into the lineitem table, using double quotes: COPY lineitem FROM "lineitem.csv" ; Read a CSV file into the lineitem table, omitting quotes: COPY lineitem FROM lineitem...V file: COPY lineitem TO 'lineitem.csv' ( FORMAT csv , DELIMITER '|' , HEADER ); Write a table to a CSV file, using double quotes: COPY lineitem TO "lineitem.csv" ; Write a table to a CSV file, omitting quotes: COPY lineitem TO lineitem.csv ; Write the...options are specified, the parentheses are required. Parameter values can be passed in with or without wrapping in single quotes. Any option that is a Boolean can be enabled or disabled in multiple ways. You can write true , ON , or 1 to enable the op... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- JSON Overview – DuckDB 9561
- 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
...act the family key's value with a JSONPath expression as a VARCHAR : SELECT j ->> '$.family' FROM example ; anatidae Using Quotes for Special Characters JSON object keys that contain the special [ and . characters can be used by surrounding them with d...ouble quotes ( " ): SELECT '{"d[u]._\"ck":42}' -> '$."d[u]._\"ck"' AS v ; 42 Pages in This Section 関連キーワード json todos DuckDB JSO...SON JSONPath and JSON Pointer Syntax Indexing Examples Loading JSON Writing JSON JSON Data Type Retrieving JSON Data Using Quotes for Special Characters... - https://man.mtool.work/duckdb/1.3/data/json/overview.html
- Struct Data Type – DuckDB 8899
- 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
..., using a row variable, or using the row function. Create a struct using the struct_pack function. Note the lack of single quotes around the keys and the use of the := operator: SELECT struct_pack ( key1 : = 'value1' , key2 : = 42 ) AS s ; Create a str...a.x . SELECT a.x FROM ( SELECT { 'x' : 1 , 'y' : 2 , 'z' : 3 } AS a ); If a key contains a space, simply wrap it in double quotes ( " ). SELECT a . "x space" FROM ( SELECT { 'x space' : 1 , 'y' : 2 , 'z' : 3 } AS a ); Bracket notation may also be used....Note that this uses single quotes ( ' ) since the goal is to specify a certain string key and only constant expressions may be used inside the brackets (no... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- Pivot Internals – DuckDB 8777
- 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
...un' ]) AS month , unnest ([ "jan" , "feb" , "mar" , "apr" , "may" , "jun" ]) AS sales FROM monthly_sales ; Note the single quotes to build a list of text strings to populate month , and the double quotes to pull the column values for use in sales . Thi... - https://man.mtool.work/duckdb/1.3/internals/pivot.html
- JSON Processing Functions – DuckDB 8237
- 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
...rs are of JSON type, but json_needle can also be a numeric value or a string, however the string must be wrapped in double quotes. json_keys(json[, path]) Returns the keys of json as a LIST of VARCHAR , if json is a JSON object. If path is specified, r...SELECT json_extract ( '{"duck": [1, 2, 3]}' , '$.duck[#-1]' ); 3 JSONPath also allows escaping syntax tokens, using double quotes: SELECT json_extract ( '{"duck.goose": [1, 2, 3]}' , '$."duck.goose"[1]' ); 2 Examples using the anatidae biological famil... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Syntax Highlighting – DuckDB 7976
- 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
...Error Highlighting The shell has support for highlighting certain errors. In particular, mismatched brackets and unclosed quotes are highlighted in red (or another color if specified). This highlighting is automatically disabled for large queries. In... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- Keywords and Identifiers – DuckDB 7854
- 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
...entifiers can use any keyword, whitespace or special character, e.g., "SELECT" and " § ? ¶ " are valid identifiers. Double quotes can be escaped by repeating the quote character, e.g., to create an identifier named IDENTIFIER "X" , use "IDENTIFIER ""X"... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- PostgreSQL Compatibility – DuckDB 7854
- 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
...s quoting preserves case, e.g., the following command creates a table named mytable but tries to query for MyTaBLe because quotes preserve the case. CREATE TABLE MyTaBLe ( x INTEGER ); SELECT * FROM "MyTaBLe" ; ERROR: relation "MyTaBLe" does not exist... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- SELECT Clause – DuckDB 7854
- 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
...s of a table: SELECT min ( COLUMNS ( * )) FROM addresses ; To select columns with spaces or special characters, use double quotes ( " ): SELECT "Some Column Name" FROM tbl ; Syntax SELECT List The SELECT clause contains a list of expressions that speci... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
DuckDB 1.3 Documentation / man.mtool.work