Results of 1 - 10 of about 14 for escape (0.005 sec.)
- Text Functions 13496
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...e value . Note that this is not a cryptographic hash. hex(string) Converts the string to hexadecimal representation. ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) us...ing case-insensitive matching. escape_character is used to search for wildcard characters in the string . instr(string, search_string) Returns location of first...gth . length(string) Number of characters in string . length_grapheme(string) Number of grapheme clusters in string . like_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) us... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Pattern Matching 10923
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...NOT ILIKE '%C'; -- false To search within a string for a character that is a wildcard ( % or _ ), the pattern must use an ESCAPE clause and an escape character to indicate the wildcard should be treated as a literal character instead of a wildcard. Se...e an example below. Additionally, the function like_escape has the same functionality as a LIKE expression with an ESCAPE clause, but using function syntax. See the Text Functions p...age for details. Search for strings with a then a literal percent sign then c : SELECT 'a%c' LIKE 'a$%c' ESCAPE '$'; -- true SELECT 'azc' LIKE 'a$%c' ESCAPE '$'; -- false Case-insensitive ILIKE with ESCAPE : SELECT 'A%c' ILIKE 'a$%c'... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Python Client API 10205
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
..., * , sep : str | None = None , na_rep : str | None = None , header : bool | None = None , quotechar : str | None = None , escapechar : str | None = None , date_format : str | None = None , timestamp_format : str | None = None , quoting : str | int | N..., * , sep : str | None = None , na_rep : str | None = None , header : bool | None = None , quotechar : str | None = None , escapechar : str | None = None , date_format : str | None = None , timestamp_format : str | None = None , quoting : str | int | N...ulls ( ) → Expression Skip NULLs, for first_value , last_value , lag , lead and nth_value . ilike ( pattern : object , * , escape : str | None = None ) → Expression like , ignoring case. is_not_null ( ) → Expression Whether this is not NULL. is_null (... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Literal Types 9435
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...DATE '1992-01-01')) t(d); Binder Error: Cannot compare values of type DATE and type VARCHAR - an explicit cast is required Escape String Literals To escape a single quote (apostrophe) character in a string literal, use '' . For example, SELECT '''' AS...s returns ' . To enable some common escape sequences, such as \n for the newline character, prefix a string literal with e (or E ). SELECT e'Hello\nworld' AS msg; ┌─...─────────────┐ │ msg │ │ varchar │ ├──────────────┤ │ Hello\nworld │ └──────────────┘ The following backslash escape sequences are supported: Escape sequence Name ASCII code \b backspace 8 \f form feed 12 \n newline 10 \r carriage return 1... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- CSV Auto Detection 9277
- When using read_csv , the system tries to automatically infer how to read the CSV file using the CSV sniffer . This step is necessary because CSV files are not self-describing and come in many different dialects. The auto-detection works ro
...ughly as follows: Detect the dialect of the CSV file (delimiter, quoting rule, escape). Detect the types of each of the columns. Detect whether or not the file has a header row. By default the system will try...to read_csv . Column name Description read_csv parameter Example Delimiter Delimiter delim , Quote Quote character quote " Escape Escape escape \ NewLineDelimiter New-line delimiter new_line \r\n Comment Comment character comment # SkipRows Number of r...ELECT Prompt FROM sniff_csv('my_file.csv'); Prompt = FROM read_csv('my_file.csv', auto_detect=false, delim=',', quote='"', escape='"', new_line='\n', skip=0, header=true, columns={...}); Detection Steps Dialect Detection Dialect detection works by atte... - https://man.mtool.work/duckdb/2.0/data/csv/auto_detection.html
- inet Extension 8489
- The inet extension defines the INET data type for storing IPv4 and IPv6 Internet addresses. It supports the CIDR notation for subnet masks (e.g., 198.51.100.0/22 , 2001:db8:3c4d::/48 ). Installing and Loading The inet extension will be tran
...bnet_contains FROM tbl; cidr subnet_contains 192.168.1.0/24 true 127.0.0.1 false 2001:db8:3c4d:15::1a2f:1a2b/96 false HTML Escape and Unescape Functions SELECT html_escape('&'); ┌──────────────────┐ │ html_escape('&') │ │ varchar │ ├──────────────────┤...│ & │ └──────────────────┘ SELECT html_unescape('&'); ┌────────────────────────┐ │ html_unescape('&') │ │ varchar │ ├────────────────────────┤ │ & │ └────────────... - https://man.mtool.work/duckdb/2.0/core_extensions/inet.html
- Reading Faulty CSV Files 8402
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...utomatically derive types from an existing table. file= people.csv delimiter = , (Auto-Detected) quote = " (Auto-Detected) escape = " (Auto-Detected) new_line = \r\n (Auto-Detected) header = true (Auto-Detected) skip_rows = 0 (Auto-Detected) date_forma...UBIGINT file_path The file path VARCHAR delimiter The delimiter used e.g., ; VARCHAR quote The quote used e.g., " VARCHAR escape The escape used e.g., " VARCHAR newline_delimiter The newline delimiter used e.g., \r\n VARCHAR skip_rows If any rows were...information about the rejected tuples. For example: FROM reject_scans; Outputs: scan_id file_id file_path delimiter quote escape newline_delimiter skip_rows has_header columns date_format timestamp_format user_arguments 5 0 faulty.csv , " " \n 0 false... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- CSV Import 7929
- Examples The following examples use the flights.csv file. Read a CSV file from disk, auto-infer options: SELECT * FROM 'flights.csv'; Use the read_csv function with custom options: SELECT * FROM read_csv('flights.csv', delim = '|', header =
...to 4 bytes, e.g., ?. Alias for sep . VARCHAR , delimiter 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...me VARCHAR YES NULL NULL NULL SELECT * FROM read_csv('flights.csv', sample_size = 20_000); If we set delim / sep , quote , escape , or header explicitly, we can bypass the automatic detection of this particular parameter: SELECT * FROM read_csv('flight... - https://man.mtool.work/duckdb/2.0/data/csv/overview.html
- File Formats 7859
- Handling Parquet Files DuckDB has advanced support for Parquet files, which includes directly querying Parquet files . When deciding on whether to query these files directly or to first load them to the database, you need to consider severa
...T Prompt FROM sniff_csv('part-0001.csv'); Prompt = FROM read_csv('file_path.csv', auto_detect=false, delim=',', quote='"', escape='"', new_line='\n', skip=0, header=true, columns={'hello': 'BIGINT', 'world': 'VARCHAR'}); Then, you can adjust read_csv c...with the rest of the options detected by the sniffer: FROM read_csv('part-*.csv', auto_detect=false, delim=',', quote='"', escape='"', new_line='\n', skip=0, header=true, columns={'hello': 'BIGINT', 'world': 'VARCHAR'}); Reducing Storage Size with Duck... - https://man.mtool.work/duckdb/2.0/guides/performance/file_formats.html
- Text Types 7702
- In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Name Aliases Description VARCHAR CHAR , BPCHAR , STRING , TEXT Variable-length character string
...oking a function that returns a text type value Strings with Special Characters To use special characters in a string, use escape string literals or dollar-quoted string literals . Alternatively, you can use concatenation and the chr character function... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
DuckDB 2.0 Documentation / man.mtool.work