Re: strangeness in pg_dump

Mathieu Arnold wrote:
> Hi
>
> I have 2 servers, a linux and a freebsd, and I don't understand why when I
> dump on one, the dumped strings looks like :
>
> "foo\r\nbar"
>
> and on the other one :
>
> "foo^M\
> bar"
>
> does someone have an idea of what compile time option is responsible for
> that ?

    Looks identical to me.

        ^M == \r == 0x0D == Carriage Return
        \ (at end of line) == \n == 0x0A == New Line

    Maybe you should use fully compatible commands to examine the
    data?


Jan

--

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