how to update a column from another database? I would like to update a field that has been delete from the backup database.
how can I update the field from an other database
If you want to write an SQL statement that affects tables from different databases, the best option is to use a postgres_fdw foreign table.

But perhaps it is simpler to extract the data from one database to a file using COPY and to load the file into the other database.