Results of 1 - 10 of about 31 for character (0.004 sec.)
- Text Functions 13572
- 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
...ULL . 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...he string to binary representation. bit_length(string) Number of bits in a string . char_length(string) Alias for length . character_length(string) Alias for length . chr(code_point) Returns a character which is corresponding the ASCII code value or Unico... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Information Schema 11647
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain 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/2.0/sql/meta/information_schema.html
- Editing 11502
- The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo
...u can also view these shortcuts from within the CLI using .help shortcuts . 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...ffer Ctrl + Left Move back a word Ctrl + Right Move forward a word Ctrl + A Move to beginning of line Ctrl + B Move back a character Ctrl + E Move to end of line Ctrl + F Move forward a character Alt + Left Move back a word Alt + Right Move forward a word...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/2.0/clients/cli/editing.html
- CSV Import 10305
- 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 =
...{'col1': 'INTEGER', 'col2': 'VARCHAR'} ). Using this option disables auto detection of the schema. 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/2.0/data/csv/overview.html
- Pattern Matching 9787
- 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
...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...the 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/2.0/sql/functions/pattern_matching.html
- Text Types 9059
- 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 effect and is only provided for compatibility Specifying a Length Limit Specifying the...mpatibility 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...al VARCHAR CHECK (length(val) <= 10) -- val has a maximum length of 10 ); The VARCHAR field allows storage of Unicode characters. Internally, the data is encoded as UTF-8. Specifying a Compression Type You can specify a compression type for a string... - https://man.mtool.work/duckdb/2.0/sql/data_types/text.html
- Literal Types 8849
- 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
...101'::INT = 5 . 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...ro'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...the Integer Literals section ; for example, '0xFF'::INTEGER and '0b101'::INTEGER . Underscores cannot 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 cannot be multiple unde... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- COPY Statement 8218
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...ories.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, where...the delimiter, quote character, and presence of a header are automatically detected: COPY lineitem FROM 'lineitem.tbl' (AUTO_DETECT true); Read the conte...ineitem.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 w... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Keywords and Identifiers 8121
- Identifiers 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_keyw
...ords() ), e.g., CREATE TABLE select (i INTEGER) 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""" . New As of DuckDB 2.0, identifiers can also... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Python Client API 7862
- 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
...seen. SQL: last . like ( pattern : object , * , escape : str | None = None ) → Expression Text match where % is any run of characters and _ is any one; negate with ~ . list ( ) → ListExpr This expression as a list: col(“tags”).list().contains(“vip”) . max...ition of the expression, parameter types). ascii ( * args : ValueOrExpr ) → Expression The Unicode code point of the first character. SQL: ascii . bin ( * args : ValueOrExpr ) → StrExpr Converts the string to binary representation. SQL: bin . bit_length (...sing the fmt syntax. SQL: format . from_base64 ( * args : ValueOrExpr ) → Expression Converts a base64 encoded string to a character string ( BLOB ). SQL: from_base64 . hamming ( * args : ValueOrExpr ) → Expression How many positions differ, for two strin... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
DuckDB 2.0 Documentation / man.mtool.work