title: How do I remove all spaces from a field in a Postgres database in an update query?
body: <p>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?</p>
  
  <p>My table is called <code>users</code> and in the column <code>fullname</code> some values look like <code>'Adam Noel'</code>.  I want to remove the space so that the new value is <code>'AdamNoel'</code> </p>
  
  <p>I have like 30k rows</p>