postgres актуализира колона със стойност от друга таблица
UPDATE t1
set "Column" = t2.column
from t2
where t2.id = t1."Id";
актуализация от select 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;