Re: Substitute

On Tue, Mar 20, 2007 at 05:54:47PM -0600, Judith wrote:
> 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

One way is with translate().  See "String Functions and Operators"
in the documentation for more information.

http://www.postgresql.org/docs/8.2/interactive/functions-string.html

-- 
Michael Fuhr