By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

pg_dump Failure

P: 1
Am running Postgres 8.2.3 on windows XP SP2. When I run the query :
pg_dump "myDatabase" > C:\myDump.sql from pgAdmin, I get the following error message.

ERROR: syntax error at or near "pg_dump"
SQL state: 42601
Character: 1

Am of the opinion that my pg_dump syntax is correct. Any suggestion is highly welcom.
Jun 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 534
... When I run the query :
pg_dump "myDatabase" > C:\myDump.sql
... ...
pg_dump is not an SQL command, it is a stand-alone utility, and you cannot run it from SQL query. Follow the link for more information.
Jun 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.