Re: Bulk Insert/Update Scenario

From: Jordan Deitch <jwdeitch(at)gmail(dot)com>
To: Mana M <manan(dot)gcs(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Bulk Insert/Update Scenario
Date: 2018-01-04 22:03:45
Message-ID: CAK1UM_ZictBXL2Z=rOpcpSK=a7JnP0JP0Z4azG=kM+=Y5HfTFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

INSERT .. ON CONFLICT can be ran as a bulk operation:

create table test(id int);
insert into test(id) values (1), (2), (3), (4);

Unless you mean you don't want to run this for every table?

Thanks,
Jordan Deitch
http://id.rsa.pub

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2018-01-04 23:04:42 Re: Replication questions - read-only and temporary read/write slaves
Previous Message Mana M 2018-01-04 21:47:49 Re: Bulk Insert/Update Scenario