postgresql upsert query

PostgreSQL DML (Data manipulation language ) statements to access and manipulate data in existing schema objects. These statements do not implicitly commit the current transaction. Some of the important data…