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 vote364 views1 answer
Bidirectional outer join sql
SQL
0 vote351 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote367 views1 answer
Import sql in postgresql
SQL
9 votes387 views1 answer
Alter table column change data type to text mysql
SQL
0 vote335 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
15 votes381 views3 answers
Postgresql change column type
SQL
0 vote385 views1 answer
How to get table id sequence postgres
SQL
0 vote364 views1 answer
What does leave do in mysql
SQL
16 votes430 views2 answers
Sql vs nosql
SQL
1 vote345 views1 answer
Postgresql transaction discard all
SQL