Postgres Pro
Downloads
Home   >   mailing lists

Re: Bulk Insert/Update Scenario - Mailing list pgsql-general

From Jordan Deitch
Subject Re: Bulk Insert/Update Scenario
Date
Msg-id CAK1UM_bUBat2jEbHxbazjjVbXFUGfj859TJkNrOB_twG7bDBnw@mail.gmail.com
Whole thread Raw
In response to Bulk Insert/Update Scenario  (Mana M <manan.gcs@gmail.com>)
Responses Re: Bulk Insert/Update Scenario  (legrand legrand <legrand_legrand@hotmail.com>)
Re: Bulk Insert/Update Scenario  (Mana M <manan.gcs@gmail.com>)
List pgsql-general
Tree view
Hi Mana, 

A starting point would be reading about the batch upsert functionality:

You would do something like:
INSERT INTO table ON CONFLICT update... 

This operation would be atomic. You can also look into deferrable constraints such that you would perform all your insert / update operations in a transaction block and accommodate for the constraints. 

I hope this helps to get you on the right track!

Thanks,
Jordan Deitch


pgsql-general by date:

Previous
From: Mana M
Date:
Subject: Bulk Insert/Update Scenario
Next
From: legrand legrand
Date:
Subject: Re: Bulk Insert/Update Scenario