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