Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] How to stop array_to_json from interpolating columnnames that weren't there - Mailing list pgsql-general

From Guyren Howe
Subject Re: [GENERAL] How to stop array_to_json from interpolating columnnames that weren't there
Date
Msg-id 76B466D4-616D-4E8C-A98D-1C03250144AC@gmail.com
Whole thread Raw
In response to Re: [GENERAL] How to stop array_to_json from interpolating columnnames that weren't there  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: [GENERAL] How to stop array_to_json from interpolating columnnames that weren't there  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Jul 19, 2017, at 20:47 , Paul Jungwirth <pj@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?

pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: [GENERAL] How to stop array_to_json from interpolating columnnames that weren't there
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] How to stop array_to_json from interpolating columnnames that weren't there