PostgreSQL - join multiple lines from one column into one string in SELECT query

Question

I'm trying to join all results from one column in SELECT query into one string.

Some of you might be familiar with C#:

string.Join(separator, stringArray)

The following statement doesn't return all results as one string

SELECT CONCAT(text) FROM orders

Does anyone have an idea of how to replicate that C# code by means of SQL?

Gordon Linoff · Accepted Answer · 2018-07-10 01:24:26Z

2

You are looking for string_agg():

select string_agg(text separator, ',')
from orders;

answered Jul 9, 2018 at 18:50

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thank you for your answer! Gave me the chance to google PostgreSQL equivalent - string_agg(DISTINCT text, ', '). Works like a charm!

@a_horse_with_no_name . . . Clearly, I was confused.