Single space for Postcode

PL/pgSQL

UPDATE TABLENAME SET postcode = (SELECT RTrim(Left((postcode),(char_length((postcode))-3))) || ' ' || Right((postcode),3));