How to insert data into a table with auto insert/update?

S

sirinotapple2022-03-27 13:08:50

PostgreSQL

sirinotapple, 2022-03-27 13:08:50

Hello, the main field in the id table,
I want data to be inserted into the table if there is no such id
, but updated if there is.
What command to do this

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Sergey Gornostaev, 2022-03-27
@sirinotapple

UPSERT

Similar questions

S

Semyon Semyonov2018-08-11 02:15:48

At what point do you need to do something? 1Reply

K

kr_ilya2020-07-25 11:47:35

Is it possible to make such a condition for the selection or do I need a separate column? 1Reply

K

kr_ilya2020-07-26 19:37:39

How to add a column to the database with data from another column? 1Reply

A

Alexander Sobolev2018-08-17 11:44:43

PostgreSQL How to compare time? 1Reply

M

Maks Hate2018-08-19 11:36:41

How to open image from Postgresql table? 4Reply

Didn't find what you were looking for?

Ask your question