Returns - ERROR: syntax error at or near "pg_dump" at character 8
Looks like you're trying to run it from psql. pg_dump is a command line utility. Run it directly from the shell command prompt (or cmd window on windows).
Pete
I've had a bit of trouble with the PostgreSQL system if that helps. (access violation with a reinstall)
To dump a database: $ pg_dump mydb > db.out" The following - $ pg_dump aurel > aurel.out - gives me "ERROR: syntax error at or near "$" at character 1" What am I missing???
The $ character is there to indicate the prompt your shell gives you. If you leave it off at the beginning of your command, things should just run fine.
Konrad
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
The information in this email is confidential and is intended for the addressee/s only. Access to this email by anyone else is unauthorised. If you are not the intended recipient, you must not read, use or disseminate the information contained in or attached to this email.
