| From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
|---|---|
| To: | kuldeep singh <kuldeeparora89(at)gmail(dot)com> |
| Cc: | hector vass <hector(dot)vass(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Insert with Jsonb column hangs |
| Date: | 2024-03-10 00:18:07 |
| Message-ID: | 65A9110C-1D19-46A4-BA42-6FB8C861E5CE@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Mar 9, 2024, at 9:01 AM, kuldeep singh <kuldeeparora89(at)gmail(dot)com> 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-03-10 11:51:31 | Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)` |
| Previous Message | Peter J. Holzer | 2024-03-09 21:34:55 | Re: creating a subset DB efficiently ? |