Results of 1 - 10 of about 11 for quoted (0.006 sec.)
- Literal Types – DuckDB 13940
- 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
...es. Note that double quotes ( " ) cannot be used as string delimiter character: instead, double quotes are used to delimit quoted identifiers . Implicit String Literal Concatenation Consecutive single-quoted string literals separated only by whitespace...near "' '" LINE 1: SELECT 'Hello' ' ' 'World' AS greeting; ^ Also note that implicit concatenation only works with single-quoted string literals, and does not work with other kinds of string values. Implicit String Conversion STRING_LITERAL instances...ported: Escape sequence Name ASCII code \b backspace 8 \f form feed 12 \n newline 10 \r carriage return 13 \t tab 9 Dollar-Quoted String Literals DuckDB supports dollar-quoted string literals, which are surrounded by double-dollar symbols ( $$ ): SELEC... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- PostgreSQL Compatibility – DuckDB 9904
- 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
...1.1 true true 1 = 1.1 false false true = 'true' true true true = 1 error true 'true' = 1 error error Case Sensitivity for Quoted Identifiers PostgreSQL is case-insensitive. The way PostgreSQL achieves case insensitivity is by lowercasing unquoted iden...E MyTaBLe ( x INTEGER ); SELECT * FROM "MyTaBLe" ; ERROR: relation "MyTaBLe" does not exist PostgreSQL does not only treat quoted identifiers as case-sensitive, PostgreSQL treats all identifiers as case-sensitive, e.g., this also does not work: CREATE...e ; ERROR: relation "preservedcase" does not exist Therefore, case-insensitivity in PostgreSQL only works if you never use quoted identifiers with different cases. For DuckDB, this behavior was problematic when interfacing with other tools (e.g., Parqu... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Keywords and Identifiers – DuckDB 9495
- 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
...ers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keywords() ), e.g., SELE...SELECT 123 AS 1col is invalid. They cannot contain whitespaces (including tabs and newline characters). Identifiers can be quoted using double-quote characters ( " ). Quoted identifiers can use any keyword, whitespace or special character, e.g., "SELEC...sitive, similarly to PostgreSQL. However, unlike PostgreSQL (and some other major SQL implementations), DuckDB also treats quoted identifiers as case-insensitive. Comparison of identifiers: Case-insensitivity is implemented using an ASCII-based compari... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- CSV Import – DuckDB 8926
- 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
...tion and assume all columns are of type VARCHAR . This option is only supported by the read_csv function. BOOL false allow_quoted_nulls Allow the conversion of quoted values to NULL values BOOL true auto_detect Auto detect CSV parameters . BOOL true au...Alias for delim ; only available in the COPY statement. VARCHAR , escape String used to escape the quote character within quoted values. VARCHAR " encoding Encoding used by the CSV file. Options are utf-8 , utf-16 , latin-1 . Not available in the COPY... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Reading Faulty CSV Files – DuckDB 8926
- 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
...than expected. In our example, any line with more than two columns would cause this error, e.g., Pedro,01-01-1992,pdet . UNQUOTED VALUE : Quoted values in CSV lines must always be unquoted at the end; if a quoted value remains quoted throughout, it wil...cause an error. For example, assuming our scanner uses quote='"' , the line "pedro"holanda, 01-01-1992 would present an unquoted value error. LINE SIZE OVER MAXIMUM : DuckDB has a parameter that sets the maximum line size a CSV file can have, which by... - https://man.mtool.work/duckdb/1.3/data/csv/reading_faulty_csv_files.html
- Relational API – DuckDB 7966
- 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
.... buffer_size : Optional[int] Buffer size in bytes. decimal : Optional[str] Character to recognize as decimal point. allow_quoted_nulls : Optional[bool] Allow quoted NULL values. filename : Optional[bool], Optional[str] Add filename column or specify f.... buffer_size : Optional[int] Buffer size in bytes. decimal : Optional[str] Character to recognize as decimal point. allow_quoted_nulls : Optional[bool] Allow quoted NULL values. filename : Optional[bool], Optional[str] Add filename column or specify f... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Text Types – DuckDB 7966
- 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
...text type value Strings with Special Characters To use special characters in string, use escape string literals or dollar-quoted string literals . Alternatively, you can use concatenation and the chr character function : SELECT 'Hello' || chr ( 10 ) |... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Extensions – DuckDB 7823
- 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
...STALL command. This repository can either be an alias, such as community , or it can be a direct URL, provided as a single-quoted string. After installing/loading an extension, the duckdb_extensions function can be used to get more information. Autoloa... - https://man.mtool.work/duckdb/1.3/extensions/overview.html
- CSV Auto Detection – DuckDB 7681
- 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
...te that using quote characters vs. no quote characters (e.g., "42" and 42 ) does not make a difference for type detection. Quoted fields will not be converted to VARCHAR , instead, the sniffer will try to find the type candidate with the highest priori... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Configuration – DuckDB 7539
- 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
...OLEAN false preserve_identifier_case Whether or not to preserve the identifier case, instead of always lowercasing all non-quoted identifiers BOOLEAN true profile_output , profiling_output The file to which profile output should be saved, or empty to p... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
DuckDB 1.3 Documentation / man.mtool.work