postgres actualizare coloana cu valoare dintr-un alt tabel
UPDATE t1
set "Column" = t2.column
from t2
where t2.id = t1."Id";
actualizare de la selectați postgresql
UPDATE
<table1>
SET
customer=subquery.customer,
address=subquery.address,
partn=subquery.partn
FROM
(
SELECT
address_id, customer, address, partn
FROM /* big hairy SQL */ ...
) AS subquery
WHERE
dummy.address_id=subquery.address_id;