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

Y

Yung_Cod3r2020-02-21 14:46:11

Why does SMTPRecipientsRefused occur? 3Reply

D

d3coy_002019-10-16 15:59:55

Analogue of query to PostgreSQL in sqlalchemy? 1Reply

M

MbIW2019-10-18 14:32:47

How to connect another typescript application to the application on the node, which is responsible for the database? 2Reply

Y

yavis232021-04-22 11:30:13

How to calculate the average value of cells with the same place of work? 1Reply

Q

quest20172017-05-22 11:43:00

Replication. Do I understand correctly? 2Reply

Didn't find what you were looking for?

Ask your question