Hacker News Reader

Comment by llarsson | Hacker News Reader

What, besides being implemented in Node, makes this substantially different from using the built in json_agg function from Postgres, as in:

https://stackoverflow.com/questions/24006291/postgresql-retu...

View on HN

I made this because I have a bunch of .sql files that I want to run against Postgres and then process the results with other tools. I cannot simply go and add json_agg to them.

You can’t select * into json_agg

Does

    SELECT json_agg(row_to_json(*))

work?

There's also json_build_object for building a JSON object and then you can use json_agg inside that.

    select array_to_json(array_agg(row_to_json(t))) from (select * from name) t

seems to work...

Reply on news.ycombinator.com