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

G

GrimJack2017-09-05 13:04:04

Why doesn't carbon parse the timestamp correctly? 2Reply

M

Max2017-02-20 11:57:06

Is it possible to set up 1 slave for multiple masters in Postgresql? 1Reply

O

olamedia.2015-02-19 11:44:10

Which database to choose for a large number of products? 2Reply

D

Dilik Pulatov2019-07-23 10:17:38

Schema in Postgresql: why is it needed and how can I use it in my projects? 2Reply

A

Alexander Ivanov2019-07-23 11:43:31

Why does the connection to the database fail even though the connection data in knex is correct? 1Reply

Didn't find what you were looking for?

Ask your question