Re: Import from Linux to Windows

I don't think so. Did a search for it in vi and nothing. It doesn't give
me an error, just exits. Last statement is "CREATE TABLE".

Sorry, not very helpful...

Thanks, Tom

-----Original Message-----
From: Andrew Dunstan [mailto:andrew@dunslane.net]
Sent: Wednesday, August 11, 2004 1:44 PM
To: Tom Haddon
Cc: pgsql-hackers-win32@postgresql.org
Subject: Re: [pgsql-hackers-win32] Import from Linux to Windows




Tom Haddon wrote:

>Hi,
>
>I have a dump file created using pg_dumpall on Linux that I'm trying to

>import into Windows. I know this dump file is good as I've tested it
>and looked at it. When I run it against the Windows version
>(8.0.0beta1) from within psql with the \i switch, it loads in the
>structure of the first database in the dump, and creates all the
>databases and users, but doesn't populate the data of the first
>database, and doesn't create the structure of all the other databases.
>
>My guess is this is a Windows formatting issue. Do I just need to do a
>search and replace on \n or \t and replace it with something?
>
>
>
>

What is the error? You don't by any chance have a ^Z somewhere in the
file, do you?

cheers

andrew