Judith написа:
> 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
> 

Look for 'replace' here -
http://www.postgresql.org/docs/8.2/static/functions-string.html.


-- 
Milen A. Radev


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Reply via email to