Search Postgresql Archives
Re: Bulk Insert/Update Scenario
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Bulk Insert/Update Scenario
From
: Jordan Deitch <jwdeitch@xxxxxxxxx>
Date
: Thu, 4 Jan 2018 17:03:45 -0500
Cc
: pgsql-general@xxxxxxxxxxxxxx
In-reply-to
: <CAJAiPv5GxqKJ4LsZsXo2Hi9kKCdfqxuNRocVVFwJ1zXTKOK=yQ@mail.gmail.com>
References
: <CAJAiPv7CPhjmtExiv0e6F_DBAbOUBGmM=ViGsZdSeJE7c+fc=A@mail.gmail.com> <
CAK1UM_bUBat2jEbHxbazjjVbXFUGfj859TJkNrOB_twG7bDBnw@mail.gmail.com
> <CAJAiPv5GxqKJ4LsZsXo2Hi9kKCdfqxuNRocVVFwJ1zXTKOK=yQ@mail.gmail.com>
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
References
:
Bulk Insert/Update Scenario
From:
Mana M
Re: Bulk Insert/Update Scenario
From:
Jordan Deitch
Re: Bulk Insert/Update Scenario
From:
Mana M
Prev by Date:
Re: Bulk Insert/Update Scenario
Next by Date:
Re: Replication questions - read-only and temporary read/write slaves
Previous by thread:
Re: Bulk Insert/Update Scenario
Next by thread:
Re: Bulk Insert/Update Scenario
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]