Re: Text data type doesn't accept newlines?

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Text data type doesn't accept newlines?
Date: 2001-06-05 16:00:33
Message-ID: 00b401c0edd8$a6e49150$22d260d1@bryan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2001-06-05 16:04:59 Calling external programs
Previous Message Rick van Dijk 2001-06-05 15:36:56 Re: What CASE tools and clients for Postgres?