Re: Postgres read jsonb content from stdin

[B Anderson <bricklen@xxxxxxxxx>]

On Sat, Dec 26, 2020 at 3:19 AM Markur Sens <markursens@xxxxxxxxx> wrote:

I'm trying to build a few data pipelines with Unix tools but can't figure out how to insert in a slurp mode (e.g. not COPY line by line) content inside a variable.

<snip>

The question is, how can I achieve the same result, without having to hit the disk due. to the temporary file.

A potential alternative to the FDW Ian Barwick mentioned could be https://github.com/pramsey/pgsql-http, which allows you to make a curl call from within Postgres directly.