PostgreSQL regexp_replace()只保留一个空格

I need to clean up a string column with both whitespaces and tabs included within, at the beginning or at the end of strings (it's a mess !). I want to keep just one whitespace between each word. Say we have the following string that includes every possible situation :I need to clean up a string column with both wh