Re: replace function in a query

> I have to write a query that does the following.
>
> select column_x from tbl_xyz
> where column_y = 'abc def ghi'
>
> new line characters i.e. '\n' in column_y should be replaced
> with a space character i.e. ' ' in this query.
> Is there any replace function that when used in the query
> with colulmn_y would do it?

Are you looking for something like this?

test=> SELECT translate ('abc
test'> def
test'> ghi', E'\n', ' ');
translate
-------------
abc def ghi
(1 row)

"translate" is described on
http://www.postgresql.org/docs/current/static/functions-string.html

Yours,
Laurenz Albe