Postgres Pro
Downloads
Home   >   mailing lists

Re: Bulk inserts into two (related) tables - Mailing list pgsql-general

From Michael Lewis
Subject Re: Bulk inserts into two (related) tables
Date
Msg-id CAHOFxGp65_ViUsQ4MfybXj5rNUPrOAzWVeiurY7Jx1TQjNr7UA@mail.gmail.com
Whole thread Raw
In response to Re: Bulk inserts into two (related) tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Bulk inserts into two (related) tables
List pgsql-general
Tree view
For each row-
Insert into organizations table if the record does not exist, returning ID.
Insert into people using that ID.

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.

Perhaps I am missing something.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Bulk inserts into two (related) tables
Next
From: Rich Shepard
Date:
Subject: Re: Bulk inserts into two (related) tables