On Wed, 25 Aug 2004 23:23:23 -0400 (EDT), Bruce Momjian
> 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,
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..
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-08-28 16:07:12|
|Subject: Re: Questions about pg_dump file |
|Previous:||From: Eduardo Vázquez Rodríguez||Date: 2004-08-27 23:16:17|
|Subject: Re: Query|