How to remove spaces in a PostgreSQL column?

Question

PostgreSQL

There is a table (in PostgreSQL) with a column containing numbers (sums): 1,000.00; 20 000.00; 300.00; 400 000.00. The data type is text.
How to remove spaces in a column?

update table set column = replace(column, ' ', '');

- didn't work
. And if you export to a SQL Server table (with the money data type) do you need the numeric data type in postgres?