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(at)gmx(dot)net http://funkturm.homeip.net/~peter