Answers for "on conflict postgres"

SQL
1

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]
Posted by: Guest on January-28-2021
0

postgresql on conflict pair

INSERT INTO tbl_Employee 
VALUES (6,'Noor')
ON CONFLICT (EmpID,EmpName)
DO NOTHING;
Posted by: Guest on October-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language