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@gmail.com>
> To: "Bob Pawley" <rjpawley@shaw.ca>
> Cc: "Postgresql" <pgsql-general@postgresql.org>
> 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@me3.com