How to convert column values to single row value in postgresql

Question

Data

  id      cust_name

  1        walmart_ca
  2        ikea_mo
  2        ikea_ca
  2        ikea_in
  1        walmart_in

when i do

  select id,cust_name from test where id=2

Query returns below output

   id  cust_name

    2  ikea_mo
    2  ikea_ca
    2  ikea_in

How can i get or store the result as single column value as shown below

    id   cust_name

     2   {ikea_mo,ikea_ca,ikea_in}

Ravi Satya Yenugula · Accepted Answer · 2019-12-13 00:07:59Z

2

you should use string_agg function and here is an example for it

select  string_agg(field_1,',') from db.schema.table;

you should mention the separator in your case its , so I am doing string_agg(field_1,',')

answered Dec 13, 2019 at 0:07

1111 silver badge7 bronze badges

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

1 Answer 1