Text data type doesn't accept newlines?

From: Randall Perry <rgp(at)systame(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Text data type doesn't accept newlines?
Date: 2001-06-05 14:22:02
Message-ID: B742634A.99BF%rgp@systame.com
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.

MySQL has the 'blob' data type which does accept newlines.

Do I have to convert all newlines to '\n' to use them in Pgsql?

--
Randy Perry
sysTame
Mac Consulting/Sales

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-05 14:35:17 Re: return value of a version-1 C function (Solved)
Previous Message Tom Lane 2001-06-05 14:12:54 Re: psql , stored procedure, triggers and errors