query to update data in a column from another table in psql code example
Example: postgres update column with value from another table
UPDATE t1
set "Column" = t2.column
from t2
where t2.id = t1."Id";
UPDATE t1
set "Column" = t2.column
from t2
where t2.id = t1."Id";