Re: Problem with Select output

On Wed, Dec 22, 2004 at 07:50:56AM -0800, srini vasan wrote:

Hi,

>    Can anybody please help me in this?

You could use the replace(text,text,text) function:

alvherre=# create table foo (a text);
CREATE TABLE
alvherre=# insert into foo values ('hola
alvherre'# ');
INSERT 155224 1
alvherre=# select * from foo;
   a
-------
 hola

(1 fila)

alvherre=# select replace(a, '\n', '\\n') from foo;
 replace
---------
 hola\n
(1 fila)

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Para tener más hay que desear menos"