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 vote253 views1 answer
View acl table oracle
SQL
0 vote261 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
56 votes488 views5 answers
Psql create user
SQL
4 votes252 views1 answer
Sql data types
SQL
0 vote288 views1 answer
GROUP BY postgres
SQL
1 vote272 views1 answer
Convert epoch to date in sql server
SQL
0 vote273 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote239 views1 answer
Sql requete number pair
SQL
12 votes282 views5 answers
Rename table in mysql
SQL
-1 vote282 views1 answer
Default username and password for oracle 11g
SQL