How to concat strings in different row on Postgres

Question

Let's say I have a table Foo and has a column name. I want to concatenate all names in Foo. For example

Table Foo

  Name
---------
  name1
  name2
  name3

I want to write a query that returns name1name2name3 or if possible name1,name2,name3.

I have done some googling and see concat function but it only concats columns of same row. I couldn't find a function or a way to accomplish this.

Zaynul Abadin Tuhin · Accepted Answer · 2019-11-07 06:27:26Z

3

use string_agg

SELECT string_agg(Foo, ', ') AS col
FROM   tbl

answered Nov 7, 2019 at 6:27

32.1k6 gold badges37 silver badges66 bronze badges

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

1 Answer 1