Update column with the value of two columns multiplied
Text values must be converted to numeric before any math operation.

UPDATE schema.table
SET    ColumnA * ColumnC::numeric  -- Use same data type as ColumnA


Have a look at this tutorial