| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Bulk inserts into two (related) tables |
| Date: | 2019-05-21 18:06:43 |
| Message-ID: | d45c7a22-16f8-8997-28da-5e95b98f0984@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 5/21/19 12:27 PM, Rich Shepard wrote:
> On Tue, 21 May 2019, Michael Lewis wrote:
>
>> For each row-
>> Insert into organizations table if the record does not exist, returning ID.
>> Insert into people using that ID.
>
> Michael,
>
> The org_id will not exist until I run the insert script.
>
>> Else, load all the data with empty ID column on person table,then just
>> update the person table afterward and drop the org name column.
>
> Then I'll copy the org_id numbers to the appropriate row(s) in the people
> table.
A Perl/Python/etc script would solve your problem.
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Will Hartung | 2019-05-21 18:27:10 | Re: Bulk inserts into two (related) tables |
| Previous Message | Fabrízio de Royes Mello | 2019-05-21 17:57:25 | Re: Re: Refresh Publication takes hours and doesn´t finish |