On Fri, May 8, 2020 at 7:32 PM Gurjeet Singh <gurjeet@singh.im> wrote: > There's no standard format that comes to mind, but perhaps an output format similar to that of (array of row_to_json()) would be desirable. For example, `select relname, relnamespace from pg_class;` would emit the following: > > [ > {"relname": "pgclass", "relnamespace": 11}, > {"relname": "pg_statistic", "relnamespace": 11}, > ]
I don't see why psql needs any special support. You can already generate this using the existing server side functions, if you want it.
That's a good point! It might still be desirable, perhaps for performance trade-off of JSON conversion on the client-side instead of on the server-side.