I don't understand the question
select json_agg(distinct field) from test;
but if you try more fields, its show f1: vale, f2, f3....
Do you prefer the following output? select json_agg(test.*) from test;
yes i did like this test is my subquey with all field i want to show
Обсуждают сегодня