In PostgreSQL, the parse_ident() function splits a qualified identifier into an array of identifiers, and removes any quoting of individual identifiers.
We pass the qualified identifier to the function when we call it. We can also specify whether or not to use strict mode.
In PostgreSQL, we can use the regexp_like() function to check whether or not a match of a POSIX regular expression occurs within a given string.
We pass the string as the first argument and the pattern as the second argument. We can also provide a flag as an optional third argument, which determines how the function behaves.
In PostgreSQL, we can use the quote_ident() function to quote identifiers in a SQL statement string.
Quotes are only added if necessary. Any embedded quotes are doubled.
In PostgreSQL, the format() function produces output formatted according to a format string. The first argument is the format string (consisting of one or more format specifiers that start with the % character), and the subsequent arguments are the values to format.
In PostgreSQL, the regexp_instr() function returns the starting or ending position of the N‘th match of a POSIX regular expression pattern to a string. If there’s no match, it returns zero.
We pass the string and pattern as arguments. The function also accepts some optional arguments that allow us to be specific with how the function works.
In PostgreSQL, we can use the substring() function to extract the first substring matching the specified POSIX or SQL regular expression.
In PostgreSQL, the regexp_count() function returns the number of times a given POSIX regular expression pattern matches in a given string.
We pass the string and pattern as arguments. We can also pass an argument to specify where to start the search. Additionally, we also have the option of specifying a flag that changes the function’s behaviour.
In PostgreSQL, we can use the quote_literal() function to quote strings within a SQL statement string.
Any embedded single-quotes and backslashes are properly doubled.
In PostgreSQL, the quote_nullable() function returns a given string suitably quoted to be used as a string literal in a SQL statement string. It returns the actual string NULL if the argument is null.
Any embedded single-quotes and backslashes are properly doubled.
In PostgreSQL, we can use the overlay() function to replace a substring within a string. The function allows us to be very specific with regards to where in the string to start the operation and how much of it should be replaced.