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

2 votes219 views1 answer
Q operator in plsql
SQL
0 vote200 views2 answers
2nd max salary query in sql
SQL
0 vote205 views2 answers
Sql 2 way of select unique
SQL
42 votes253 views6 answers
Rename table sql server
SQL
8 votes190 views1 answer
Oracle add month
SQL
3 votes190 views1 answer
What is having clause
SQL
0 vote194 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote219 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote217 views1 answer
Change role postgres
SQL
0 vote205 views2 answers
Many to many flask-sqlalchemy
SQL