PostgreSQL Function Reference

SPLIT_PART

Splits a string on the specified delimiter and returns the given part.

PostgreSQL 17.5

SPLIT_PART(string, delimiter, part_number)

string

The source string.

delimiter

The delimiter to split by.

part_number

The part number to return (1-based).

Examples

PostgreSQL 17.5

SELECT SPLIT_PART('a|b|c', '|', 2)