Removing spaces - Mailing list pgsql-general

I have a field of type text that has a value like

'hello   \nworld   \n'

I would like to remove the trailing blanks between the last character
and the newline. I would like to use replace with a regx  like
/[ ]+\n/\n/ but it does not seem to work.