📄️ PostgreSQL ASCII() Function
The PostgreSQL ASCII() function returns an ASCII code value of a character. In the case of UTF\-8, the ASCII() function returns the Unicode code point of the character.
📄️ PostgreSQL CHR() Function
The PostgreSQL CHR() function converts an integer ASCII code to a character or a Unicode code point to a UTF8 character.
📄️ PostgreSQL CONCAT() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL CONCAT() function to concatenate two or more strings into one.
📄️ PostgreSQL CONCAT_WS() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL CONCAT_WS() function to concatenate strings into a single string, separated by a specified separator.
📄️ PostgreSQL FORMAT() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL FORMAT() function to format a string based on a template.
📄️ PostgreSQL LEFT() Function
The PostgreSQL LEFT() function returns the first n characters in the string.
📄️ PostgreSQL LENGTH() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL LENGTH() functions to get the number of characters of a string.
📄️ PostgreSQL INITCAP() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL INITCAP() function to convert a string to a proper case.
📄️ PostgreSQL LOWER() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL LOWER() function to convert the string to all lowercase.
📄️ PostgreSQL LPAD() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL LPAD() function to pad a string on the left to a specified length with a sequence of characters.
📄️ PostgreSQL LTRIM() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL LTRIM() function to remove specified characters from the beginning of a string.
📄️ PostgreSQL MD5() Function
The PostgreSQL MD5() function calculates the MD5 hash of a string and returns the result in hexadecimal.
📄️ PostgreSQL POSITION() Function
The PostgreSQL POSITION() function returns the location of the first instance of a substring within a string.
📄️ PostgreSQL REGEXP_MATCHES() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL REGEXP_MATCHES() function to extract substrings from a string based on a regular expression.
📄️ PostgreSQL REPEAT() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL REPEAT() function to repeat a string a specified number of times.
📄️ PostgreSQL REPLACE() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL REPLACE() function to replace a substring with a new one.
📄️ PostgreSQL REVERSE() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL REVERSE() function to reverse the characters within a string.
📄️ PostgreSQL RIGHT() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL RIGHT() function to return the last n characters in a string.
📄️ PostgreSQL RPAD() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL RPAD() function to extend a string to a length by filing characters.
📄️ PostgreSQL RTRIM() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL RTRIM() function to remove specified characters from the end of a string.
📄️ PostgreSQL SPLIT_PART() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL SPLIT_PART() function to retrieve a part of a string at a specified position after splitting.
📄️ PostgreSQL SUBSTRING() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL SUBSTRING() function to extract a substring from a string.
📄️ PostgreSQL TO_CHAR() Function
The PostgreSQL TO_CHAR() function converts a timestamp, an interval, an integer, a double\-precision, or a numeric value to a string.
📄️ PostgreSQL TO_NUMBER() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL TO_NUMBER() function to convert a character string to a numeric value according to a specified format.
📄️ PostgreSQL TRANSLATE() Function
The PostgreSQL TRANSLATE() function performs several single\-character, one\-to\-one translations in one operation.
📄️ PostgreSQL TRIM() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL TRIM() function to remove specified prefixes or suffixes (or both) from a string.
📄️ PostgreSQL UPPER() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL UPPER() function to convert a string to uppercase.
📄️ PostgreSQL REGEXP_REPLACE() Function
Summary: in this tutorial, you will learn how to use the PostgreSQL REGEXP_REPLACE() function to replace strings that match a regular expression.