Functions / String Functions And Operators

regexp_split_to_array

Splits string using a POSIX regular expression as the delimiter, producing an array of results; see Section 9.7.3.

Reading PG 18current·documented in 20 of 27 versions, 8.3 to 20

Signatures & examples

regexp_split_to_array ( string text, pattern text [, flags text ] ) → text[]

Splits string using a POSIX regular expression as the delimiter, producing an array of results; see Section 9.7.3.

regexp_split_to_array('hello world', '\s+') → {hello,world}

Version history 4

Definition snapshot: b7bd9cda · English manual source