From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Bulk inserts into two (related) tables |
Date: | 2019-05-21 16:56:38 |
Message-ID: | alpine.LNX.2.20.1905210945100.6551@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm cleaning and formatting a 800-line data file to be inserted into a
database. Some of the input file fields will be inserted into an
'organizations' table letting postgres assign sequential org_id numbers.
Other fields will be inserted into a separate 'people' table associated with
each organization. The people table insert allows postgres to assign the
person_id number and this table's foreign key, people.org_id ==
organizations.org_id.
I could insert all new rows into the organizations table, then produce a
list of the org_id and org_name to manually insert the foreign key in the
related people table. Time and effort intense.
Is there a way to insert the two tables sequentially without manually adding
the organizations.org_id to the appropriate foreign key column (people.org_id)
of the people table?
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-05-21 17:03:09 | Re: Bulk inserts into two (related) tables |
Previous Message | Frank Alberto Rodriguez | 2019-05-21 15:11:49 | Re: PITR based recovery in a primary/standby cluster setup |