Re: pg_dump

From: jcradock(at)me3(dot)com
To: jcradock(at)me3(dot)com
Cc: "Bob Pawley" <rjpawley(at)shaw(dot)ca>, "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump
Date: 2006-11-23 22:14:37
Message-ID: 33249.66.63.75.235.1164320077.squirrel@secure.me3.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(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
>>
>
>
>
> -----
> James Cradock, jcradock(at)me3(dot)com
>
>
>
> ---------------------------(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(at)me3(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard P. Welty 2006-11-23 22:17:07 Re: pg_dump
Previous Message Peter Wilson 2006-11-23 22:14:08 Re: pg_dump