Splits string using a POSIX regular expression as the delimiter, producing a set of results; see Section 9.7.3.
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 3
- PG 18 → 19changed
- PG 13 → 14changed
- PG 12 → 13changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source