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

24 votes270 views2 answers
Alter table delete column
SQL
0 vote258 views1 answer
Mysql local password denied
SQL
0 vote283 views2 answers
How to install mssql on mac
SQL
0 vote257 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
7 votes316 views3 answers
Sql update where id
SQL
0 vote265 views1 answer
Sql server select top 2 of each group
SQL
5 votes270 views1 answer
Postgresql functions
SQL
2 votes231 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote638 views1 answer
Sql field equals multiple values
SQL
0 vote311 views1 answer
Postgres - Login and connect as default user
SQL