regexp_count
: counts the number of places that match the regular expression in a stringregexp_instr
: returns the starting of the Nth match of a regular expression in a stingregexp_like
: returns true if a regular expression has a match in a string.https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP