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 vote309 views1 answer
Oracle function select into
SQL
0 vote378 views1 answer
How to install postgresql on wsl
SQL
0 vote365 views2 answers
Select index table oracle
SQL
0 vote378 views1 answer
Systems sql
SQL
0 vote363 views4 answers
Stored procedure sql
SQL
0 vote365 views1 answer
Call function sql oracle with output put line
SQL
0 vote378 views2 answers
Nosqlbooster query other collection
SQL
1 vote409 views1 answer
Concat first name and last name in mysql
SQL
5 votes383 views1 answer
AND OR NOT operators sql
SQL
1 vote361 views1 answer
Table infromation in sql server
SQL