The following bug has been logged online:
Bug reference: 5617
Logged by: Leo Shklovskii
Email address: leo@thermopylae.net
PostgreSQL version: 8.4.4
Operating system: Windows 7 (x86)
Description: pg_restore behaves unexpectedly on 'invalid' command
line
Details:
If I put options after the filename to use for pg_restore.exe then it
behaves in a very unintuitive way. So, for example:
pg_restore.exe -U postgres d8.dump -d d8a
This should either result in the command working as expected, or an error
that the args weren't correct. I understand that arg parsing can be hard in
situations so the latter would be perfectly fine.
Instead, I get a dump of the SQL generated to the screen which is a mess and
its hard to figure out that you did something wrong.