Horton

Re: Text data type doesn't accept newlines?

Bryan White <bryan@arcamax.com>

View thread View on postgr.es
From: "Bryan White" <bryan@arcamax.com>
To: <pgsql-general@postgresql.org>
Date: 2001-06-05T16:00:33Z
Lists: pgsql-general 
> 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 have never had a problem storing newlines in a text field.  What interface
are you using?
The only ascii character that I have found I have to escape is the single
quote character.
---------
Bryan White