PostrSQL TRIM- Remove blanks

Use TRIM function for (clear white spaces) remove leading and trailing blanks from column of every row in a table

Example

UPDATE table SET column = TRIM(column);

Or

UPDATE table SET column = TRIM(both ' " " ' from column);