Answers for "append data to column postgre"

postgres add column from another table

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

PostgreSQL add column

ALTER TABLE mytable
ADD COLUMN column1 VARCHAR,
ADD COLUMN column2 REAL;

INSERT INTO mytable (column1)
VALUES (v1), (v2), (vn);