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

1 vote250 views3 answers
Nth highest salary
SQL
1 vote253 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote229 views1 answer
Cannot start database server xampp mac os
SQL
0 vote278 views1 answer
Delete from table where length sql
SQL
0 vote210 views1 answer
Sql script get all stored procedures from database
SQL
0 vote247 views1 answer
Postgresql on conflict pair
SQL
2 votes240 views1 answer
Removing view
SQL
0 vote272 views1 answer
Postgres list tables and row counts
SQL
3 votes234 views1 answer
Ssh check mysql version
SQL
1 vote247 views1 answer
Regular expression in sql server
SQL