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

1 vote189 views1 answer
Base nosql
SQL
0 vote200 views1 answer
Drop unique
SQL
0 vote187 views1 answer
Mysqldump ignore table
SQL
0 vote216 views1 answer
Find how many tables in database sql query
SQL
9 votes184 views2 answers
Mysql change value
SQL
14 votes281 views1 answer
How to export db from mysql
SQL
2 votes203 views1 answer
Sql server check for value in multiple columns
SQL
1 vote210 views1 answer
Sample in sql
SQL
8 votes274 views2 answers
Change name of colum in sql table
SQL
14 votes241 views3 answers
Inner join sql oracle
SQL