Buradasın

PostgreSQL String Functions Overview

Yapay zekadan makale özeti

Basic Functions: ^@ checks if strings start with each other
ascii returns numeric code of first character
chr returns character with given code
concat combines text strings with optional separators
format formats arguments according to specified string
String Manipulation: initcap converts first letter of each word to uppercase
left returns first n characters of string
length returns number of characters in string
reverse reverses string character order
split_part divides string at delimiter occurrences
Advanced Features: regexp_count counts occurrences of pattern matches
regexp_like checks if pattern matches
string_to_array and string_to_table split strings with delimiters
to_ascii converts strings to ASCII from different encodings
to_bin, to_hex, and to_oct convert numbers to different formats
unistr evaluates escaped Unicode characters
Identifier Functions: quote_ident and quote_literal format strings for SQL statements
parse_ident splits qualified identifiers into array
pg_client_encoding returns current client encoding name