Lazier alternative to row_to_json ?

From: Florents Tselai <florents(dot)tselai(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Lazier alternative to row_to_json ?
Date: 2021-11-01 11:18:46
Message-ID: 43A856C7-353A-49CA-A99F-C1E81E8D5935@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have the following simple query

select row_to_json(d) from documents d

The output of this goes to script that expects new-line-delimited stream of JSON objects.

But as-is, ti looks like the server’s memory fills-up before ti starts emitting results.

Any ideas how I could bypass this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-11-01 14:05:38 Re: Lazier alternative to row_to_json ?
Previous Message Jimmy A 2021-11-01 06:10:53 Naked EXISTS vs SELECT EXISTS very different performance.