Re: Postgres read jsonb content from stdin

Поиск
Список
Период
Сортировка
От B Anderson
Тема Re: Postgres read jsonb content from stdin
Дата
Msg-id CAGrpgQ-cJ91JYCO5PsBauVYuzOYTY4F3vttd4GiZ++YMDCYk7w@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres read jsonb content from stdin  (Markur Sens <markursens@gmail.com>)
Список pgsql-general
Дерево обсуждения

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem with ssl and psql in Postgresql 13
Следующее
От: Brajendra Pratap Singh
Дата:
Сообщение: Partitioned Table conversion to Non-Partition table in postgresql open source