Results of 1 - 10 of about 25 for character (0.004 sec.)
- Text Functions – DuckDB 13981
- 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 functions and operators for examining and manipulating STRING values . Name Description string[index] Extracts a single character using a (1-based) index. string[begin:end] Extracts a string using slice conventions similar to Python. Missing begin or e...in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . array_extract(string, index) Extracts a single character from a string using a (1-based) index . array_slice(list, begin, end) Extracts a sublist or substring using slice conventi...ons . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width chara... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Information Schema – DuckDB 11773
- 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
...information about a specific column or table. DuckDB's implementation is based on PostgreSQL's information schema . Tables character_sets : Character Sets Column Description Type Example character_set_catalog Currently not implemented – always NULL . VARC...HAR NULL character_set_schema Currently not implemented – always NULL . VARCHAR NULL character_set_name Name of the character set, currently...implemented as showing the name of the database encoding. VARCHAR 'UTF8' character_repertoire Character repertoire, showing UCS if the encoding is UTF8 , else just the encoding name. VARCHAR 'UCS' form_of_... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- CSV Import – DuckDB 10278
- 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
...struct (e.g., {'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection. STRUCT (empty) comment Character used to initiate comments. Lines starting with a comment character (optionally preceded by space characters) are completel...y ignored; other lines containing a comment character are parsed only up to that point. VARCHAR (empty) compression Method used to compress CSV files. By default this is detect...vailable in the COPY statement. VARCHAR (empty) decimal_separator Decimal separator for numbers. VARCHAR . delim Delimiter character used to separate columns within each line, e.g., , ; \t . The delimiter character can be up to 4 bytes, e.g., ?. Alias for... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Editing – DuckDB 10129
- 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
...tcuts that are based on Emacs mode of readline . Below is a list of available commands. Moving Key Action Left Move back a character Right Move forward a character Up Move up a line. When on the first line, move to previous history entry Down Move down a...er Ctrl + Left Move back a word Ctrl + Right Move forward a word Ctrl + A Move to beginning of buffer Ctrl + B Move back a character Ctrl + E Move to end of buffer Ctrl + F Move forward a character Alt + Left Move back a word Alt + Right Move forward a wo...ast history entry Alt + N Search the history Alt + P Search the history Changing Text Key Action Backspace Delete previous character Delete Delete next character Ctrl + D Delete next character. When buffer is empty, end editing Ctrl + H Delete previous ch... - https://man.mtool.work/duckdb/1.3/clients/cli/editing.html
- Pattern Matching – DuckDB 9564
- 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
...ng itself; in that case LIKE acts like the equals operator. An underscore ( _ ) in pattern stands for (matches) any single character; a percent sign ( % ) matches any sequence of zero or more characters. LIKE pattern matching always covers the entire stri...he active locale: SELECT 'abc' ILIKE '%C' ; -- true SELECT 'abc' 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 shou...ld be treated as a literal character instead of a wildcard. See an example below. Additionally, the function like_escape has the same functionality as a LIKE e... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Literal Types – DuckDB 8883
- 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
...1000 cannot be. Other Numeric Literals Non-integer numeric literals can be denoted with decimal notation, using the period character ( . ) to separate the integer part and the decimal part of the number. Either the integer part or the decimal part may be...o's constant SELECT 1e-10 ; -- 1 ångström Underscores in Numeric Literals DuckDB's SQL dialect allows using the underscore character _ in numeric literals as an optional separator. The rules for using underscores are as follows: Underscores are allowed in...integer, decimal, hexadecimal and binary notation. Underscores can not be the first or last character in a literal. Underscores have to have an integer/numeric part on either side of them, i.e., there can not be multiple und... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Text Types – DuckDB 8634
- 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
...Types Copy Markdown Text Types 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 VARCHAR(n) CHAR(n) , BPCHAR(n) , STRING(n) , TEXT(n) Variable-length character string. The maximum length n has no...ity reasons with other systems that do require a length to be specified for strings. If you wish to restrict the number of characters in a VARCHAR column for data integrity reasons the CHECK constraint should be used, for example: CREATE TABLE strings ( v... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Keywords and Identifiers – DuckDB 8369
- 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
...erved 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 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., "SELECT" and " § ? ¶ " are valid id...entifiers. Double quotes can be escaped by repeating the quote character, e.g., to create an identifier named IDENTIFIER "X" , use "IDENTIFIER ""X""" . Deduplicating Identifiers In some cases, du... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- COPY Statement – DuckDB 8269
- 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
...ies.csv' ( HEADER ); Copy the contents of lineitem.tbl into the lineitem table, where the contents are delimited by a pipe character ( | ): COPY lineitem FROM 'lineitem.tbl' ( DELIMITER '|' ); Copy the contents of lineitem.tbl into the lineitem table, whe...re the delimiter, quote character, and presence of a header are automatically detected: COPY lineitem FROM 'lineitem.tbl' ( AUTO_DETECT true ); Read the con...neitem.csv' ; Copy the contents of the lineitem table to the file lineitem.tbl , where the columns are delimited by a pipe character ( | ), including a header line: COPY lineitem TO 'lineitem.tbl' ( DELIMITER '|' ); Use tab separators to create a TSV file... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Reading Multiple Files – DuckDB 7804
- 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
...lename, or use a glob syntax to read multiple files that match a pattern. Wildcard Description * Matches any number of any characters (including none) ** Matches any number of subdirectories (including none) ? Matches any single character [abc] Matches on...e character given in the bracket [a-z] Matches one character from the range given in the bracket Note that the ? wildcard in globs is... - https://man.mtool.work/duckdb/1.3/data/multiple_files/overview.html
DuckDB 1.3 Documentation / man.mtool.work