Re: Postgres read jsonb content from stdin

2020-12-27 Thread B Anderson
On Sat, Dec 26, 2020 at 3:19 AM Markur Sens 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. > > The question is, how can I achieve the same result, without having to h

Re: Postgres read jsonb content from stdin

2020-12-26 Thread Markur Sens
Hello, Hadn't really thought of using a foreign table up at this point... thanks for that. Will the first solution handle formatting issues (e.g. single quotes) gracefully? I think I'd tried it in the past and it didn't work. PD: I have such a script that handle's the intricacies but it'd still

Re: Postgres read jsonb content from stdin

2020-12-26 Thread Ian Lawrence Barwick
2020年12月26日(土) 20:19 Markur Sens : > > Hello, > > 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. > > Consider the following script (using a heredoc) > > json_url="https://f