Functions / String Functions And Operators
Returns substrings within the first match of the POSIX regular expression pattern to the string, or substrings within all such matches if the g flag is used; see Section 9.7.3.
Reading PG 18current·documented in 20 of 27 versions, 8.3 to 20
regexp_matches ( string text, pattern text [, flags text ] ) → setof text[]Returns substrings within the first match of the POSIX regular expression
pattern to the string, or substrings within all such matches if the g flag is used; see Section 9.7.3.regexp_matches('foobarbequebaz', 'ba.', 'g') → {bar}
{baz}Definition snapshot: b7bd9cda · English manual source