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 vote316 views1 answer
What is the essence of SQL?
SQL
0 vote324 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
3 votes367 views3 answers
Postgresql random number
SQL
14 votes356 views3 answers
Inner join sql oracle
SQL
2 votes357 views1 answer
Sql string_agg
SQL
0 vote350 views1 answer
Clear query cache sql server
SQL
0 vote336 views1 answer
Limiting query result using where in sql
SQL
5 votes315 views1 answer
Oracle list packages
SQL
0 vote323 views1 answer
Oracle character index
SQL
1 vote339 views3 answers
SELECT * FROM
SQL