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
