UPDATE

Descripción: Replaces values of columns in a table

UPDATE table SET col = expression [, ...]
    [ FROM fromlist ]
    [ WHERE condition ]

Por ejemplo,

update lola set lola.dedonde = lupe.p from lupe where lola.proced = lupe.c;