What is equivalent for LISTAGG in postgres?

Question

I need to replace the Oracle driver with the latest postgres.

Postgres does not know the LISTAGG function. I have to contact the values separated by commas.

What is equivalent to the Oracle LISTAGG function in Postgres?

Thanks.

+8

function database oracle postgresql listagg

cy221 Apr 10 '15 at 9:11

source share

1 answer

w͏̢in̡͢g͘̕ed̨p̢͟a͞n͏͏t̡͜͝he̸r̴ · Accepted Answer · 2015-04-10T09:14:05+0000

Equivalent function in Postgres string_agg()

 select string_agg(col,',') from my_table

string_agg : input values are combined into a string, separated by a separator