On Wed, May 13, 2020 at 2:01 PM Chapman Flack wrote:
>
> Seems like a lot of work just to get json-shaped query results from psql,
+1. If we look at the amount of work needed for the hybrid approach
you describe, compared to running CSV result through something like
csv2json, there's a 100% chanc
On 05/13/20 16:16, Gurjeet Singh wrote:
> On Wed, May 13, 2020 at 1:14 PM Gurjeet Singh wrote:
>>
>> Arguably, delivering JSON (with its repeating attribute names in every
>> element of the array, dquotes and commas) is more network intensive
>> than converting the resultset to JSON on [client] si
On Wed, May 13, 2020 at 1:14 PM Gurjeet Singh wrote:
>
> Arguably, delivering JSON (with its repeating attribute names in every
> element of the array, dquotes and commas) is more network intensive
> than converting the resultset to JSON on network side.
s/network side/client side/
Best regards,
On Wed, May 13, 2020 at 12:50 PM Robert Haas wrote:
>
> On Mon, May 11, 2020 at 4:42 PM Gurjeet Singh wrote:
> > 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.
>
> If there's a perf
On Mon, May 11, 2020 at 4:42 PM Gurjeet Singh wrote:
> 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.
If there's a performance problem with the server's code here, we
should probably try t
On Mon, May 11, 2020 at 1:24 PM Robert Haas wrote:
> On Fri, May 8, 2020 at 7:32 PM Gurjeet Singh 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
On Fri, May 8, 2020 at 7:32 PM Gurjeet Singh 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:
>
> [
> {"rel
On Fri, May 8, 2020 at 12:10 PM Pavel Stehule
wrote:
>
>
> pá 8. 5. 2020 v 21:08 odesílatel Gurjeet Singh napsal:
>
>>
>> On Fri, May 8, 2020 at 12:01 PM Pavel Stehule
>> wrote:
>>
>>> Hi
>>>
>>> pá 8. 5. 2020 v 20:18 odesílatel Gurjeet Singh
>>> napsal:
>>>
psql currently supports HT
pá 8. 5. 2020 v 21:08 odesílatel Gurjeet Singh napsal:
>
> On Fri, May 8, 2020 at 12:01 PM Pavel Stehule
> wrote:
>
>> Hi
>>
>> pá 8. 5. 2020 v 20:18 odesílatel Gurjeet Singh napsal:
>>
>>> psql currently supports HTML, CSV, etc output formats. I was
>>> wondering if supporting JSON format
On Fri, May 8, 2020 at 12:01 PM Pavel Stehule
wrote:
> Hi
>
> pá 8. 5. 2020 v 20:18 odesílatel Gurjeet Singh napsal:
>
>> psql currently supports HTML, CSV, etc output formats. I was
>> wondering if supporting JSON format was requested or discussed in past. If
>> there's desire for this feat
Hi
pá 8. 5. 2020 v 20:18 odesílatel Gurjeet Singh napsal:
> psql currently supports HTML, CSV, etc output formats. I was wondering
> if supporting JSON format was requested or discussed in past. If there's
> desire for this feature, perhaps we can add it to the TODO list on wiki so
> someone
psql currently supports HTML, CSV, etc output formats. I was wondering
if supporting JSON format was requested or discussed in past. If there's
desire for this feature, perhaps we can add it to the TODO list on wiki so
someone can pick it up and work on it in future.
Best regards,
--
Gurjeet S
12 matches
Mail list logo
