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

5 votes303 views1 answer
Oracle create table comment
SQL
4 votes343 views1 answer
Rename stored procedure in sql server
SQL
0 vote350 views1 answer
Stratified sampling sql
SQL
10 votes297 views4 answers
Join with multiple conditions sql
SQL
3 votes327 views3 answers
Mysql declare variable
SQL
0 vote289 views1 answer
Dns slave zone convert
SQL
4 votes317 views1 answer
For loop postgresql
SQL
6 votes301 views1 answer
Check Table Exists
SQL
2 votes284 views3 answers
Application.properties spring boot mysql
SQL
3 votes314 views2 answers
Install mysql powershell
SQL