[GENERAL] Text data type doesn't accept newlines?

[Randall Perry]

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





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster