On Mon, May 11, 2020 at 1:24 PM Robert Haas <robertmh...@gmail.com> wrote:
> On Fri, May 8, 2020 at 7:32 PM Gurjeet Singh <gurj...@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.
Best regards,
--
Gurjeet Singh http://gurjeet.singh.im/
