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@gmu.edu>
> To: Tom Lane <tgl@sss.pgh.pa.us>
> Cc: Stephen Frost <sfrost@snowman.net>, pgsql-general@postgresql.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@gmu.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 -------
>