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.