On Mon, Mar 05, 2007 at 10:28:04AM -0500, dlivesay@xxxxxxxxx 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
