Re: Text data type doesn't accept newlines?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: Text data type doesn't accept newlines?
Дата
Msg-id 200106051615.f55GFR902068@jupiter.us.greatbridge.com
обсуждение исходный текст
Ответ на Text data type doesn't accept newlines?  (Randall Perry <rgp@systame.com>)
Список 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 по дате отправления:

Предыдущее
От: "Bryan White"
Дата:
Сообщение: Re: Text data type doesn't accept newlines?
Следующее
От: Vivek Khera
Дата:
Сообщение: turning off stderr message for postmaster