On Mon, Mar 05, 2007 at 10:28:04AM -0500, [EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
