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

13 votes108 views2 answers
Display users in mysql
SQL
2 votes105 views1 answer
Q operator in plsql
SQL
0 vote130 views1 answer
Mariadb used space
SQL
0 vote72 views1 answer
Oracle sql replace string in clob
SQL
23 votes104 views6 answers
Delete all rows from table sql
SQL
2 votes114 views1 answer
Add default sql server
SQL
0 vote116 views2 answers
Python mysql create table if not exists
SQL
0 vote104 views2 answers
Select columns from 2 tables with foreign key
SQL
5 votes113 views1 answer
Oracle generate list of dates in between a date range
SQL
23 votes110 views4 answers
How to show all users in mysql
SQL