Horton

Text data type doesn't accept newlines?

Randall Perry <rgp@systame.com>

View thread View on postgr.es
From: Randall Perry <rgp@systame.com>
To: <pgsql-general@postgresql.org>
Date: 2001-06-05T14:22:02Z
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