Postgres upsert

Upsert postgres

INSERT INTO table_name(column_list)
VALUES(value_list)
ON CONFLICT target [DO NOTHING]

-- or 
    
INSERT INTO table_name(column_list)
VALUES(value_list)
ON CONFLICT target DO UPDATE SET column_1 = value_1, .. WHERE condition]

Source: postgresqltutorial.com

Similar codes

0 vote185 views1 answer
Sql DATE = GETDATE()
SQL
-1 vote189 views1 answer
What is in operator
SQL
1 vote197 views1 answer
Mysql average of multiple columns
SQL
0 vote151 views1 answer
Mysql insert with foreign key
SQL
9 votes208 views4 answers
Last mysql
SQL
-1 vote183 views1 answer
Insert results of a stored procedure into a temporary table
SQL
1 vote176 views1 answer
Sql server 2012 query history
SQL
2 votes208 views1 answer
Oracle trace file
SQL
0 vote237 views1 answer
Sql server current time without date
SQL
1 vote165 views1 answer
Oracle lock user
SQL