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 vote190 views1 answer
Sql server sleep
SQL
-2 votes185 views1 answer
Use of where in left join in mysql
SQL
0 vote173 views2 answers
Show slave status mysql
SQL
0 vote186 views1 answer
Mysql root permission denied lost
SQL
4 votes164 views1 answer
Oracle show error line number
SQL
5 votes177 views1 answer
Mysql last day of next month
SQL
0 vote193 views1 answer
Typeorm raw sql
SQL
0 vote153 views2 answers
Spring properties file for db
SQL
0 vote174 views1 answer
Datetime postgres typeorm
SQL
5 votes206 views1 answer
Oracle get ddl
SQL