I work with postgresql and i have a database like this [duplicate]

Question

Col1 Col2
_________
A   |  1
A   |  2
A   |  3
B   |  4
B   |  5
B   |  6

and i need to obtain something like this

col1 list
________
A   | 1,2,3
B   | 4,5,6

i'm still beginner give me the most simple alternative

You have table like that, not a database (which is a bunch of tables.) — jarlh
– jarlh, Commented May 11, 2020 at 8:58

zealous · Accepted Answer · 2020-05-11 08:59:09Z

1

Try the following with array_agg

select
    col1,
    array_agg(col2)
from yourTable
group by
    col1

or with string_agg

select
    col1,
    string_agg(col2, ', ')
from yourTable
group by
    col1

answered May 11, 2020 at 8:59

zealous

7,5434 gold badges20 silver badges39 bronze badges

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

1 Answer 1