Re: Questions about pg_dump file

On Wed, 25 Aug 2004 23:23:23 -0400 (EDT), Bruce Momjian
<pgman@candle.pha.pa.us> wrote:
> John Browne wrote:
> > I had a-couple of questions regarding the text formatting in the pg_dump file.
> >
> > First, when dumping my database, I seem to be getting inconsistent
> > end-of-line characters.  Some lines end with the *NIX-style \n and
> > some end with Windows-style \r\n.  Now, I have created this database
> > over about a-year or so and I have tested various clients (psql,
> > pgadminIII, etc) during that time.  I'm suspecting they are coming
> > from one of the Windows clients, but shouldn't the \r\n end-of-line
> > characters be converted to \n when a dump is created?  Is this the
> > expected behavior?  I know the output of pg_dump could be piped
> > through perl or sed or something to strip/convert them.  I just didn't
> > know if there was an easier way.
>
> We should handle \n or \r\n just fine, though there is a fix in 7.4.5
> for that.

Oh, pg_dump handles it just fine, but the problem is you end up with a
mixture of different EOL characters in the dump file.  Shouldn't
pg_dump create the dump file with consistent \n *NIX style EOL
characters throughout the entire file, instead of carrying over the
\r\n EOL characters from user-defined function definitions, views,
etc.?

The only reason I stumbled across the fact there were \r\n characters
in the dump file is because I started versioning my postgres schema in
my Subversion repository. :-)  Just thought it was odd the \r\n
characters were there..