Re: Insert with Jsonb column hangs

[Rob Sargent <robjsargent@xxxxxxxxx>]

On Mar 9, 2024, at 9:01 AM, kuldeep singh <kuldeeparora89@xxxxxxxxx> wrote:



Copy may not work in our scenario since we need to join data from multiple tables & then  convert it to json using  row_to_json . This json data eventually  needs to be stored in a target table . 

Wait. You're getting the data from the database, converting that into json and writing that back to the database?  Can you not feed the json consumer from those sources?