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