Module string

String functions

https://www.postgresql.org/docs/current/functions-string.html

Statics

_LINKME_ELEMENT_chr_int4_varchar 🔒

_LINKME_ELEMENT_initcap_varchar_varchar 🔒

_LINKME_ELEMENT_left_varchar_int4_varchar 🔒

_LINKME_ELEMENT_lpad_varchar_int4_varchar 🔒

_LINKME_ELEMENT_lpad_varchar_int4_varchar_varchar 🔒

_LINKME_ELEMENT_quote_ident_varchar_varchar 🔒

_LINKME_ELEMENT_quote_literal_varchar_varchar 🔒

_LINKME_ELEMENT_quote_nullable_varchar_varchar 🔒

_LINKME_ELEMENT_reverse_varchar_varchar 🔒

_LINKME_ELEMENT_right_varchar_int4_varchar 🔒

_LINKME_ELEMENT_rpad_varchar_int4_varchar 🔒

_LINKME_ELEMENT_rpad_varchar_int4_varchar_varchar 🔒

_LINKME_ELEMENT_starts_with_varchar_varchar_boolean 🔒

_LINKME_ELEMENT_to_ascii_varchar_varchar 🔒

_LINKME_ELEMENT_to_hex_int4_varchar 🔒

_LINKME_ELEMENT_to_hex_int8_varchar 🔒

Functions

chr

Returns the character with the specified Unicode code point.

chr_int4_varchar 🔒

initcap

Capitalizes the first letter of each word in the given string.

initcap_varchar_varchar 🔒

left

Returns the first n characters in the string. If n is a negative value, the function will return all but last |n| characters.

left_varchar_int4_varchar 🔒

lpad

Extends the given string on the left until it is at least the specified length, using the specified fill character (or a space by default).

lpad_fill

Extends the string to the specified length by prepending the characters fill. If the string is already longer than the specified length, it is truncated on the right.

lpad_varchar_int4_varchar 🔒

lpad_varchar_int4_varchar_varchar 🔒

quote_ident

Returns the given string suitably quoted to be used as an identifier in an SQL statement string. Quotes are added only if necessary (i.e., if the string contains non-identifier characters or would be case-folded). Embedded quotes are properly doubled.

quote_ident_varchar_varchar 🔒

quote_literal

quote_literal(string text) quote_literal(value anyelement)

quote_literal_varchar_varchar 🔒

quote_nullable

quote_nullable(string text)

quote_nullable_varchar_varchar 🔒

reverse

Reverses the characters in the given string.

reverse_varchar_varchar 🔒

right

Returns the last n characters in the string. If n is a negative value, the function will return all but first |n| characters.

right_varchar_int4_varchar 🔒

rpad

Extends the given string on the right until it is at least the specified length, using the specified fill character (or a space by default).

rpad_fill

Extends the given string on the right until it is at least the specified length, using the specified fill string, truncating the string if it is already longer than the specified length.

rpad_varchar_int4_varchar 🔒

rpad_varchar_int4_varchar_varchar 🔒

starts_with

Returns true if the given string starts with the specified prefix.

starts_with_varchar_varchar_boolean 🔒

to_ascii

Converts the input string to ASCII by dropping accents, assuming that the input string is encoded in one of the supported encodings (Latin1, Latin2, Latin9, or WIN1250).

to_ascii_varchar_varchar 🔒

to_hex_i32

Converts the given integer to its equivalent hexadecimal representation.

to_hex_i64

to_hex_int4_varchar 🔒

to_hex_int8_varchar 🔒