Re: JSON output from psql
| От | Gurjeet Singh |
|---|---|
| Тема | Re: JSON output from psql |
| Дата | |
| Msg-id | CABwTF4WSGVF+BDVMG1O3AVYUrristMs9C5z2T+4v2i4AzWf+zg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: JSON output from psql (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: JSON output from psql
|
| Список | pgsql-hackers |
On Mon, May 11, 2020 at 1:24 PM Robert Haas <robertmhaas@gmail.com> wrote:
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.
В списке pgsql-hackers по дате отправления: