Re: pg_dump

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(dot)neuwirth(at)gmail(dot)com>
> To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
> Cc: "Postgresql" <pgsql-general(at)postgresql(dot)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
>

--
------------------------------------------------------------------------
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.