Functions / String Functions And Operators

regexp_split_to_table

Splits string using a POSIX regular expression as the delimiter, producing a set 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_table ( string text, pattern text [, flags text ] ) → setof text

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

regexp_split_to_table('hello world', '\s+') → hello
world

Version history 4

Definition snapshot: b7bd9cda · English manual source