string_agg ( value text, delimiter text ) → textConcatenates the non-null input values into a string. Each value after the first is preceded by the corresponding
delimiter (if it's not null).FUNCTIONS / AGGREGATE FUNCTIONS
string_agg
Read PG 18 manual ↗Concatenates the non-null input values into a string.
Signatures & examples
string_agg ( value bytea, delimiter bytea ORDER BY input_sort_columns ) → byteaConcatenates the non-null input values into a string. Each value after the first is preceded by the corresponding
delimiter (if it's not null).Version history 4
- PG 16 → 17changed
- PG 12 → 13changed
- PG 9.3 → 9.4changed
- PG 9.1 → 9.2changed
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source