Re: Questions about pg_dump file - Mailing list pgsql-novice

From John Browne
Subject Re: Questions about pg_dump file
Date
Msg-id ccc6061040827220722018a6@mail.gmail.com
Whole thread Raw
In response to Re: Questions about pg_dump file  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Questions about pg_dump file
Re: Questions about pg_dump file
List pgsql-novice
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..

pgsql-novice by date:

Previous
From: Eduardo Vázquez Rodríguez
Date:
Subject: Re: Query
Next
From: Tom Lane
Date:
Subject: Re: Questions about pg_dump file