Re: pg_dump bud with functions - Mailing list pgsql-bugs

From Ivan
Subject Re: pg_dump bud with functions
Date
Msg-id 927759848.20051031122409@mail.ru
Whole thread Raw
In response to Re: pg_dump bud with functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hello,

TL> Ivan <Ivan-Sun1@mail.ru> writes:
>> When I create a function in sql or plpgsql languages,
>> their body text is stored in the database files with
>> 0D 0A line ends (I checked it in a hex editor).

>> If I create plain backup using pg_dump
>> it generates functions with
>> 0D 0D 0A on the end of the body lines,

TL> Good ol' Windows :-(.  Try writing the dump file with "pg_dump -f file"
TL> instead of "pg_dump >file" ... does that make it better?

This problem is actual for pg_dumpall because there is no -f file
option for it - output is always written to standard output.
Is it possible to add this option to pg_dumpall too?

Thank you for support!


--
Best regards,
 Ivan                            mailto:Ivan-Sun1@mail.ru

pgsql-bugs by date:

Previous
From: tomas@tuxteam.de (Tomas Zerolo)
Date:
Subject: Re: importing from 8.0.3 unicode problem
Next
From: "Roddi Walker"
Date:
Subject: BUG #2010: COPY command does not recognise UTF-8 text files with leading BOM