3 ms·select array_to_json(array_agg(row_to_json(t))) from (select * from name) t seems to work...by eddyg 7y agoselect array_to_json(array_agg(row_to_json(t))) from (select * from name) t seems to work...