Re: Bulk inserts into two (related) tables

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Bulk inserts into two (related) tables
Дата
Msg-id alpine.LNX.2.20.1905220535340.1484@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Bulk inserts into two (related) tables  (Francisco Olarte <folarte@peoplecall.com>)
Ответы Re: Bulk inserts into two (related) tables
Re: Bulk inserts into two (related) tables
Список pgsql-general
On Wed, 22 May 2019, Francisco Olarte wrote:

> I'm curious, what org_id do you put (manually) to the people? you must
> have some way to match it ( like, say, "I have an organization line,
> followed by lines for people in this organization"

Francisco,

The first data entered was in small chunks so I'd add a few rows to the
organization table, output a file of org_id and org_name, then use the
source data to associate that org_id to the people associated with it.

With this new data source I want to populate the two tables more quickly. I
think the time consuming part is associating people with their organization.
I'll do more thinking about this.

I don't do perl, though.

Thanks,

Rich



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

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: Bulk inserts into two (related) tables
Следующее
От: Pierre Couderc
Дата:
Сообщение: how to write correctly this update ?