Re: pg_dumpall: does not exist database

I would call you an genius, but ... :-)

Anyway, that worked and is the solution!
postgres=# update pg_database set datname='foodmart' where datname
like 'foodmart%';
UPDATE 1
postgres=# drop database foodmart;
DROP DATABASE

THANKS!

On Apr 25, 2006, at 11:13 AM, Jim Buttafuoco wrote:

>
> why not just
>
> update pg_database set datname='foodmart' where datname like
> 'foodmart%';
>
>
>
> ---------- Original Message -----------
> From: Ari Kahn <akahn1(at)gmu(dot)edu>
> To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org
> Sent: Tue, 25 Apr 2006 11:08:09 -0400
> Subject: Re: [GENERAL] pg_dumpall: does not exist database
>
>> On Apr 25, 2006, at 10:51 AM, Tom Lane wrote:
>>
>>> Ari Kahn <akahn1(at)gmu(dot)edu> writes:
>>>> You'll notice the database foodmart has a carriage return or new
>>>> line. I still can't figure out how to get rid of it though.
>>>
>>> Perhaps something along the lines of
>>>
>>> drop database "foodmart
>>> ";
>>>
>>> regards, tom lane
>>
>> I tried that. Doesn't work.
>> Using "od -a" I did determine that there is a CR (carriage return) in
>> the name.
>>
>> 0001240 sp sp sp | sp nl sp f o o d m a r
>> t cr
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
> ------- End of Original Message -------
>