Re: Insert with Jsonb column hangs

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Insert with Jsonb column hangs
Дата
Msg-id 65A9110C-1D19-46A4-BA42-6FB8C861E5CE@gmail.com
обсуждение исходный текст
Ответ на Re: Insert with Jsonb column hangs  (kuldeep singh <kuldeeparora89@gmail.com>)
Список pgsql-general


On Mar 9, 2024, at 9:01 AM, kuldeep singh <kuldeeparora89@gmail.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?

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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: creating a subset DB efficiently ?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Query plans not identical for `id in(1,2,3)` and `(id=1 or id=2 or id=3)`