Re: Questions about pg_dump file

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.

> Second question... I have noticed that a pg_dump file keeps the text
> formatting, ie, tabs, spaces, etc. for any user-defined functions.
> The function looks like it should, and is readable, in the pg_dump
> file, with all of it's formatting. A view, however, ends up all on
> the same line. This is fine for simple views, but for more
> complicated view definitions it can be difficult to read. Is there a
> way to get postgres/pg_dump to keep it's text formatting (tabs,
> spaces, etc) for the view definitions like it does for functions? Or
> is this even feasable?

This is improved in 8.0beta1.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073