A very frequently asked question here is how to do an upsert, which is what MySQL calls INSERT ... ON DUPLICATE UPDATE and the standard supports as part of the MERGE operation. Given that PostgreS...

I know there are a lot related questions with many answers, but I have a bit of a more nuanced question. I have been doing reading on different insert techniques for mass records, but are there lim...

When H2 database is in Postgres Mode, how do I check if it supports following statement (upsert / on conflict) INSERT INTO event_log_poller_state (aggregate_type, consumer_group_id, value) VALUES ...

I am trying to implement an upsert in postgres (an insert on constraint update). This is what my sql looks like: INSERT into "foo" ("bar", "moo", "baz") VALUES (1, 2, 3), (3, 4, 5) ON CONFLICT O...

I am writing a data-mining program, which bulk inserts user data. The current SQL is just a plain bulk insert: insert into USERS( id, username, profile_picture) select unnest(array['12345']), u...

I am using MongoDB 2, and I want to update multiple documents and upsert a value like processed:true into the collection. But MongoDB c# api only allows us to either Update Multiple Records or Ups...

I have an airflow job upserting the columns of my table on daily basis via INSERT ON CONFLICT statement. The table contains a field updated_mode of type enum which is set to automatic when the row ...

I need to perform UPSERT / INSERT OR UPDATE against a SQLite Database. There is the command INSERT OR REPLACE which in many cases can be useful. But if you want to keep your id's with autoincremen...

In am currently working with PostgreSQL 9.5 and was wondering if the is a possibility to include names of 2 constraints in the ON CONFLICT ON CONSTRAINT statement. My sql is below INSERT INTO LIVE...

Is there a built-in way to make upsert (insert if not exists) in Mongoid? Or should I check if an item exists first and only after that make insert/update?

As instructed by this comment. CREATE OR REPLACE FUNCTION test_upsert( _parent_id int, _some_text text) RETURNS text LANGUAGE plpgsql AS $func$ DECLARE a text; BEGIN INSERT INTO parent_tree ...

Very often, I want to run a query on one of my users where I want a row stored and associated with that user, in a 1-to-1 relationship. So let's say (this is just an arbitrary example), that I have...

I'm trying to ignore inserts if a tag and url combo exist already: INSERT INTO tags(tag, url) VALUES (?, ?); ON CONFLICT(url, tag) IGNORE I have a UNIQUE INDEX on (tag, url) CREATE UNIQUE INDE...

I have two dataframes, DF1 and DF2. DF1 is the master and DF2 is the delta. The data from DF2 should be inserted into DF1 or used to update the DF1 data. Lets say the DF1 is of the following format...

I have a Postgres table with a unique constraint on multiple columns, one of which can be NULL. I only every want to allow one record with NULL in that column for each combination. create table my_...

I'm working with Windows Azure Table Storage and have a simple requirement: add a new row, overwriting any existing row with that PartitionKey/RowKey. However, saving the changes always throws an e...

Does a SELECT query following an INSERT … ON CONFLICT DO NOTHING statement always find a row, given the default transaction isolation (read committed)? I want to INSERT-or-SELECT a row in one table...

I have a problem with ON CONFLICT DO UPDATE in Postgres 9.5 when I try to use more than one source in the FROM statement. Example of working code: INSERT INTO new.bookmonographs (citavi_id, abst...

I need to write an SQL query for MS-Access 2000 so that a row is updated if it exists, but inserted if it does not. (I believe this is called an "upsert") i.e. If row exists... UPDATE Table1 SET...

I need to write a row to the database regardless of whether it already exists or not. Before using NHibernate this was done with a stored procedure. The procedure would attempt an update and if no ...

I'm not sure if this is possible or not, but I'm trying to get into the nitty gritty of what I can do in postgres 9.6.1 and this seems like maybe its possible. So given this table: DROP TABLE IF E...

I have a table CREATE TABLE foo ( f0 int, time_stamp timestamp, CONSTRAINT foo_pk PRIMARY KEY (f0) ) I need to write to this table in high volumes, so performance is key. Sometimes, I w...

http://en.wikipedia.org/wiki/Upsert Insert Update stored proc on SQL Server Is there some clever way to do this in SQLite that I have not thought of? Basically I want to update three out of four co...

We use DynamoDB UpdateItem. This acts as an "upsert" as we can learn from the documentation Edits an existing item's attributes, or adds a new item to the table if it does not already ex...

From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is executed. My code now does a select and if no result is returned it does an insert. I really don't lik...