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

From Jan Wieck
Subject Re: Text data type doesn't accept newlines?
Date
Msg-id 200106051615.f55GFR902068@jupiter.us.greatbridge.com
Whole thread Raw
In response to Text data type doesn't accept newlines?  (Randall Perry <rgp@systame.com>)
List pgsql-general
Randall Perry wrote:
> 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?

    I  don't  see  a reason why it shouldn't accept them, and the
    last time I stuffed html pages into via  libpgtcl  it  worked
    IIRC.

    What interface does your client use?


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-general by date:

Previous
From: "Bryan White"
Date:
Subject: Re: Text data type doesn't accept newlines?
Next
From: Vivek Khera
Date:
Subject: turning off stderr message for postmaster