| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Gurjeet Singh <gurjeet(at)singh(dot)im> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Postgres Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: JSON output from psql |
| Date: | 2020-05-11 20:23:51 |
| Message-ID: | CA+TgmoahevkF=czqJMkb=-zDL+ENXF95ZSQy0qa6KX=jk-9pqA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, May 8, 2020 at 7:32 PM Gurjeet Singh <gurjeet(at)singh(dot)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.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2020-05-11 20:25:38 | Re: making update/delete of inheritance trees scale better |
| Previous Message | Tom Lane | 2020-05-11 20:22:40 | Re: making update/delete of inheritance trees scale better |