encode() — PostgreSQL string function
encode(): convert bytea value into some ascii-only text string. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…
Function Category: String Functions
format() — PostgreSQL string function
format(): format text message. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.
left() — PostgreSQL string function
left(): extract the first n characters. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.
lpad() — PostgreSQL string function
lpad(): left-pad string to length. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.
ltrim() — PostgreSQL string function
ltrim(): trim selected characters from left end of string. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…
name() — PostgreSQL string function
name(): convert text to name. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.
quote_ident() — PostgreSQL string function
quote_ident(): quote an identifier for usage in a querystring. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…
quote_literal() — PostgreSQL string function
quote_literal(): quote a literal for usage in a querystring. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…
quote_nullable() — PostgreSQL string function
quote_nullable(): quote a possibly-null literal for usage in a querystring. PostgreSQL string functions — signature, volatility, version applicability and an…
regclass() — PostgreSQL string function
regclass(): convert text to regclass. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.