3 ms·

Does SELECT json_agg(row_to_json(*)) work?

• newaccoutnas 7y ago
  There's also json_build_object for building a JSON object and then you can use json_agg inside that.
• eddyg 7y ago
  select array_to_json(array_agg(row_to_json(t))) from (select * from name) t seems to work...