I haven't tried it on Windows but most probably you need to issue that command from the command prompt/terminal, not when you're within psql. Log in as a superuser and give that command with the qualified psql path.
Payal Singh, OmniTi Computer Consulting Inc. Junior Database Architect, Phone: 240.646.0770 x 253
On Fri, Oct 18, 2013 at 9:57 AM, Erin Jonaitis <jonaitis@wisc.edu> wrote:
Hello!
I am trying to restore data from an SQL dump. I am using Windows 7, PostgreSQL version 9.3, pgAdmin III 1.18.0.
Here is what I did.
1)I used the pgAdmin III interface to create a new database.
2)I selected this db in the console and selected Plugins > PSQL console.
3)Now I have a psql window open with the following prompt: dbname=#
4)I tried typing the following: psql –f M:\LongitudinalDB\backups\2013.10.02\uw.sql and got the following error: Invalid command \LongitudinalDB. Try \? For help.
5)OK, so maybe the backslashes are the problem. I then tried psql –f M:/LongitudinalDB/backups/2013.10.02/uw.sql and got no error.
6)However, none of the data or tables appeared in the db – it looks just as it did as a fresh db.
7)I tried a few other things in the psql window, deliberately typing nonsense. No error messages then, either, just a fresh prompt.
