Bob Pawley wrote:
No
joy
pg_dump aurel > aurel.out
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)
Bob
----- Original Message ----- From: "Konrad Neuwirth"
<k.neuwirth@xxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, November 23, 2006 1:45 PM
Subject: Re: [GENERAL] pg_dump
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
--
Peter Wilson
T: 01414 160505
M: 07796 656566
http://www.yellowhawk.co.uk
|
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. |
|
