Bulk inserts into two (related) tables

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

Responses

Browse pgsql-general by date

  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