Answers for "update column value in postgresql"

postgres update column with value from another table

UPDATE t1 
set "Column" = t2.column
from t2 
where t2.id = t1."Id";

Posted by: Guest on November-06-2020

update column data type postgres

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;

Posted by: Guest on April-03-2020

Code answers related to "update column value in postgresql"