Function Category: String Functions

split_part() — PostgreSQL string function

split_part(): split string by field_sep and return field_num. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

string_to_table() — PostgreSQL string function

string_to_table(): split delimited text. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

strpos() — PostgreSQL string function

strpos(): position of substring. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

substr() — PostgreSQL string function

substr(): extract portion of string. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

textlen() — PostgreSQL string function

textlen(): length. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

to_ascii() — PostgreSQL string function

to_ascii(): encode text from DB encoding to ASCII text. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…

to_number() — PostgreSQL string function

to_number(): convert text to numeric. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

translate() — PostgreSQL string function

translate(): map a set of characters appearing in string. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…

unistr() — PostgreSQL string function

unistr(): unescape Unicode characters. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

varchar() — PostgreSQL string function

varchar(): adjust varchar() to typmod length. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.