How to overwrite rows in PostgreSql?

Question

PostgreSQL

Good afternoon,
there is a query executed via JDBC - INSERT INTO TableName( id, name) VALUES ('1', 'new_name');
An entry with this key already exists, and duplicate key value violates unique constraint "TableName_pkey" occurs,
how to completely overwrite the entire entry if an entry with this key already exists?
ON CONFLICT DO UPDATE - wants to specify which fields need to be updated.
You need to do a complete overwrite.

Answer 1

Postgre has no such mechanism.
If you often have such a situation, then it is better to start with update, because upsert is a rather expensive thing.