On Jul 19, 2017, at 20:47 , Paul Jungwirth <p...@illuminatedcomputing.com>
wrote:
>
>> which is great. I have an array of perfect JSON objects. Now I just need
>> to turn that into a single JSON object.
>
> I think you're saying you want it as a single JSON *array*, right? An object
> of objects doesn't make sense. Assuming that's right, this seems to work:
>
> db1=# select json_agg(schemata) from schemata;
> json_agg
> ----------------------------------------------------------------------------------------------------------
> [{“catalog_name":"db1","schema_name":"information_schema","schema_name_address":"/information_schema"},
Thanks. Seeking greater understanding, why is json_agg(*) not equivalent?
