How do I remove all spaces from a field in a Postgres database in an update query?

postgresql

Solution

update users
  set fullname = replace(fullname, ' ', '');

Problem

What would be the proper syntax used to run an update query on a table to remove all spaces from the values in a column? My table is called `users` and in the column `fullname` some values look like `'Adam Noel'`. I want to remove the space so that the new value is `'AdamNoel'` I have like 30k rows

Original source