Re: strangeness in pg_dump - Mailing list pgsql-general

From Jan Wieck
Subject Re: strangeness in pg_dump
Date
Msg-id 200206031335.g53DZqG02363@saturn.janwieck.net
Whole thread Raw
In response to strangeness in pg_dump  (Mathieu Arnold <mat@mat.cc>)
Responses Re: strangeness in pg_dump  (Mathieu Arnold <mat@mat.cc>)
List pgsql-general
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 #



pgsql-general by date:

Previous
From: "frank_lupo@email.it"
Date:
Subject: EXCEPTION idea
Next
From: Neil Conway
Date:
Subject: Re: reverse of extract epoch?