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

7 votes348 views3 answers
Foreign key oracle
SQL
4 votes329 views1 answer
Describe table mysql
SQL
22 votes322 views4 answers
Tsql rename table
SQL
0 vote351 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote319 views1 answer
How to get all values in a table mysql in c#
SQL
6 votes314 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote353 views1 answer
How to retrive the today date sql
SQL
-1 vote318 views1 answer
Ssms connect with connection string
SQL
3 votes340 views2 answers
Oracle privileges users
SQL
0 vote344 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL