| From: | B Anderson <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Markur Sens <markursens(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgres read jsonb content from stdin |
| Date: | 2020-12-28 03:01:43 |
| Message-ID: | CAGrpgQ-cJ91JYCO5PsBauVYuzOYTY4F3vttd4GiZ++YMDCYk7w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brajendra Pratap Singh | 2020-12-28 06:49:22 | Partitioned Table conversion to Non-Partition table in postgresql open source |
| Previous Message | Tom Lane | 2020-12-27 22:32:54 | Re: Problem with ssl and psql in Postgresql 13 |