Postgres update several tables
There is a structure.
I want to change at the same time.
header_has_elembased on sample in the table
courtlanda last edited by
PostgreSQL has long-standing constructions with which new values can be reverted as a table. And no scumbags with stores for such a small task.
The code may have to be adapted to this task, because it is likely that I did not correctly understand the author, but it shows how to use the task and achieve the desired effect of only minor changes.
with new_data as ( update data set elem_id = %new_value% where header_id = %header_id% returning * ) update header_has_elem set elem_id = (select d.elem_id from new_data d where d.header_id = header_id limit 1) where id in (select a.id from analiz a join new_data d on d.header_id = a.header_id)