how to insert and update data into postgresql from node js using if condition

Question

i have to "UPDATE" data in postgresql if data is already present in database and "INSERT" i.e create a new user_Id and insert data using IF condition. i have tried with this but i am not getting output. please help me if you know .

if(data.Details){
    db.query('UPDATE Details SET fullName = $2,address= $3,phone = $4 WHERE user_id = $1 RETURNING *', [query, data.Details.fullName, data.Details.address, data.Details.phone],function(err,details) {
                if (err) return callback(new Error('error'));
             })
}else{
db.query('INSERT INTO Details(user_id,fullName,address,phone) VALUES($1,$2,$3,$4) RETURNING *', [query, data.Details.fullName, data.Details.address, data.Details.phone],function(err,details) {
                                if (err) return callback(new Error('error'));

                            })
}

Possible duplicate of Insert, on duplicate update in PostgreSQL? — vitaly-t
– vitaly-t, Commented May 11, 2017 at 12:19

Horia Coman · Accepted Answer · 2017-05-11 12:05:14Z

1

If you want to get fancy, you can also use UPSERT/ON CONFLICT in Postgres 9.5 and later.

It is designed for this exact use case, and executes as a single "instruction", rather than having to do a query check whether something exists, and another one to update or insert, both in a transaction.

answered May 11, 2017 at 12:05

Horia Coman

8,8112 gold badges25 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ncank Over a year ago

actually upsert is way better than manually checking. because right after you "checked/selected" for a record, another request or client can insert it before this session.

Collectives™ on Stack Overflow

how to insert and update data into postgresql from node js using if condition

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related