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

10 votes151 views1 answer
Oracle all_dependencies
SQL
1 vote126 views1 answer
Psql import backup file for windows
SQL
0 vote123 views1 answer
Mysql select where field is a value
SQL
0 vote139 views1 answer
Plpgsql create function
SQL
0 vote126 views1 answer
Sql select all records from all tables where not empty
SQL
1 vote110 views1 answer
Error code 1055
SQL
3 votes129 views1 answer
Oracle undo tablespace schema
SQL
11 votes118 views1 answer
Sql query to find duplicates in column
SQL
0 vote167 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
-1 vote162 views1 answer
Difference berween database and data base management system
SQL