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
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
http://id.rsa.pub
Understood, this makes sense. Thanks for this feedback
On Wed, Jan 3, 2018 at 4:36 PM, Magnus Hagander wrote:
>
>
> On Wed, Jan 3, 2018 at 6:53 PM, Steve Atkins wrote:
>
>>
>> > On Jan 3, 2018, at 6:00 AM, Jordan Deitch wrote:
>> >
>> > Thanks
Thanks for the feedback! I will continue to address these issues, and I
intend on adding #postgresql IRC logs as well :-)
This software was written by me particularly for this purpose; I will clean
up / comment, then publish the source to my github - I'll shoot a reply
here with that sometime in th
This project serves to organize and archive the postgres mailing list:
http://pg.rsa.pub/
Let me know what you think, or if you have any suggestions.
I left email addresses off the site to protect privacy.
p.s: you can click messages to collapse the tree
Thanks
