From: | Mathieu Arnold <mat(at)mat(dot)cc> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | terry(at)greatgulfhomes(dot)com, Jan Wieck <janwieck(at)yahoo(dot)com> |
Subject: | Re: strangeness in pg_dump |
Date: | 2002-06-03 13:50:23 |
Message-ID: | 3449096969.1023119423@andromede.reaumur.absolight.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--On lundi 3 juin 2002 09:35 -0400 Jan Wieck <janwieck(at)yahoo(dot)com> wrote:
> 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.
well, they do not I believe.
> ^M == \r == 0x0D == Carriage Return
> \ (at end of line) == \n == 0x0A == New Line
that is right, but, in the first case, it is not '\r' + '\n' but '\\' + 'r'
+ '\\' + '\n'
> Maybe you should use fully compatible commands to examine the
> data?
--On lundi 3 juin 2002 09:31 -0400 terry(at)greatgulfhomes(dot)com wrote:
> Are you sure the files are different format???
well, I use :
pg_dump -c -h pgsqlhost -h file database
on the 2 servers, the database being on another server...
I don't understand.
--
Mathieu Arnold
From | Date | Subject | |
---|---|---|---|
Next Message | Mathieu Arnold | 2002-06-03 14:07:54 | Re: strangeness in pg_dump |
Previous Message | Neil Conway | 2002-06-03 13:39:57 | Re: reverse of extract epoch? |