Postgres Pro
Downloads
Home   >   mailing lists

Re: Text data type doesn't accept newlines? - Mailing list pgsql-general

From Bryan White
Subject Re: Text data type doesn't accept newlines?
Date
Msg-id 00b401c0edd8$a6e49150$22d260d1@bryan
Whole thread Raw
In response to Text data type doesn't accept newlines?  (Randall Perry <rgp@systame.com>)
Responses Re: Text data type doesn't accept newlines?  (Randall Perry <rgp@systame.com>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Fran Fabrizio
Date:
Subject: Calling external programs
Next
From: Jan Wieck
Date:
Subject: Re: Text data type doesn't accept newlines?