Substitute - Mailing list pgsql-sql

Hello everybody....

somebody knows, how I can substitute in a query if a field contains a 
character that I want to be shown with other character?
for example if I have a \n I want to shows me a ~ in the result of the 
select

thanks in advanced!!