Issue working with Postgres on Windows
The PSQL Console in pgadmin3 consists of opening a terminal and running psql --username yourname [other options] dbname inside it for you, with yourname and dbname being taken from what you've used to log in pgadmin3.

This console runs the psql interpreter which expects either psql meta-commands starting with backslash, or plain SQL commands.

When typing this:


  `psql -U postgres -d postgres -f dump.sql`


it's taken as an unfinished SQL sentence for the interpreter, so it's just waiting for the rest. That's why nothing happens as you wrote. This command is out of context.

What you want is:

\i /path/to/dump.sql


\i means 'include' and is the meta-command to feed a file as a stream of SQL commands to the interpreter.
You'll see the output of these commands on the terminal and when finished , type \q to end the session.