Re: psql JSON output format

pá 17. 5. 2024 v 16:04 odesílatel Robert Haas <robertmhaas(at)gmail(dot)com>
napsal:

> On Fri, May 17, 2024 at 9:42 AM Christoph Berg <myon(at)debian(dot)org> wrote:
> > Thanks for summarizing the thread.
> >
> > Things mentioned in the thread:
> >
> > 1) rendering of SQL NULLs - include or omit the column
> >
> > 2) rendering of JSON values - both "quoted string" and "inline as
> > JSON" make sense
> >
> > 3) not quoting numeric values and booleans
> >
> > 4) no special treatment of other datatypes like arrays or compound
> > values, just quote them
> >
> > 5) row format: JSON object or array (array would be close to CSV
> > format)
> >
> > 6) overall format: array of rows, or simply print each row separately
> > ("JSON Lines" format, https://jsonlines.org/)
> >
> > I think 1, 2 and perhaps 6 make sense to have configurable. Two or
> > three \pset options (or one option with a list of flags) don't sound
> > too bad complexity-wise.
> >
> > Or maybe just default to "omit NULL columns" and "inline JSON" (and
> > render null as NULL).
>
> If we're going to just have one option, I agree with making that the
> default, and I'd default to an array of row objects. If we're going to
> have something configurable, I'd at least consider making (4)
> configurable.
>
> It's tempting to just have one option, like \pset jsonformat
>
> nullcolumns=omit;inlinevalues=json,array;rowformat=object;resultcontainer=array
> simply because adding a ton of new options just for this isn't very
> appealing. But looking at how long that is, it's probably not a great
> idea. So I guess separate options is probably better?
>

+1 for separate options

lot of these proposed options can be used for XML too

Regards

Pavel

> --
> Robert Haas
> EDB: http://www.enterprisedb.com
>
>
>