Concatenating mutiple rows in postgresql into single rows

Question

I have a table containing many rows

I want to all rows of a column to be concatenated to single row

e.g

   columns
  -------
    a
    b
    c
    d
    e

i want to have following result

    a,b,c,d,e

roman · Accepted Answer · 2013-07-10 06:46:40Z

2

create table test (a text);

insert into test
values ('a'), ('b'), ('c'), ('d'), ('e');

select string_agg(a, ',') from test

answered Jul 10, 2013 at 6:46

roman

118k30 gold badges205 silver badges209 bronze badges

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

Comments

Dinup Kandel · Accepted Answer · 2013-07-10 06:33:00Z

1

SELECT 
array_to_string(array_agg("column"),',') AS yourColumn
FROM Table1

check to see you answer demo

answered Jul 10, 2013 at 6:26

Dinup Kandel

2,5054 gold badges22 silver badges39 bronze badges

Note that on modern versions (9.0 and later, string_agg() can be used instead).