update column value from another table column value in postgres

Question

I have two tables as below:

i want to update a icon value in xyz table with specific id. For this i am using below query.

update xyz t set image = (select image from abc t1 where id = t.abcId);

But this update all the values. Can any one please update this.

Laurenz Albe · Accepted Answer · 2018-08-09 13:04:49Z

2

You forgot to add a WHERE clause to the UPDATE statement, that's why all rows are updated.

Try adding the following at the end of the statement:

WHERE t.id = 42

Then only the xyz with id 42 will be updated.

answered Aug 9, 2018 at 13:04

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

Comments

mskfisher · Accepted Answer · 2018-08-10 13:12:38Z

1

I suggest this query:

update xyz t 
set image = 
    (select image from abc t1 where t1.id = t.abcId) 
where t.id="**ID That You Want To Update**";

mskfisher

3,4124 gold badges37 silver badges50 bronze badges

answered Aug 10, 2018 at 4:17

Hiren Patel

1,14713 silver badges38 bronze badges