CODE EXAMPLE FOR SQL

postgres add foreign key to existing table

UPDATE student
SET name = institute.inst_name
FROM institute
WHERE student.student_id = institute.inst_id;