Re: Text data type doesn't accept newlines?

Randall Perry writes:

> I have a logging database that logs errors. The error messages contain
> newlines. Pgsql doesn't accept them on insert in a text data field.

I don't think so.

peter=# create table test1 (a text);
CREATE
peter=# insert into test1 values ('with
peter'# newline');
INSERT 145809 1
peter=# select * from test1;
      a
--------------
 with
newline
(1 row)

Please make a more detailed report if you have a problem.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter