On Mon, Mar 05, 2007 at 10:28:04AM -0500, dlivesay@covad.net wrote:
> Here's something I've always wondered. When you dump a database, the dumped file
> looks like ordinary SQL, but if I load it into a query editor window and try to
> execute it, I always get syntax errors. The specific errors vary, but it always
> makes it impossible to reload the data that way.
>
> In the past I've just used psql -f [file] [schema] to reload them, but I'm
> trying to do this on Windows, and I can't seem to get anything to work from the
> command shell, so I'm really stuck.
It should work perfectly fine to restore it using psql -f on Windows as
well, I'd recommend that you look into why that's not working and try to
fix that instead.
//Magnus