On Sat, Dec 26, 2020 at 3:19 AM Markur Sens <markursens(at)gmail(dot)com> 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.