Sorry. The command will output ... *AS* SQL with comments. > Bob, > > This command: > > pg_dump aurel > > ...should output the structure and contents of your "aurel" database to > your screen SQL with comments. > > What version of PostgreSQL are you running and on what operating system? > > Jim > >> No joy >> >> pg_dump aurel > aurel.out >> >> Returns - >> ERROR: syntax error at or near "pg_dump" at character 8 >> >> 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 >> > > > > ----- > James Cradock, jcradock@xxxxxxx > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > ----- James Cradock, jcradock@xxxxxxx
