From: | Ari Kahn <akahn1(at)gmu(dot)edu> |
---|---|
To: | jim(at)contactbda(dot)com |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dumpall: does not exist database |
Date: | 2006-04-25 15:19:57 |
Message-ID: | 535A3FDF-9CDB-4B6B-BC69-78CB9F9AE236@gmu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 -------
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moseley | 2006-04-25 15:46:26 | Anyone install 8.1 on Debian Stable? |
Previous Message | Jim Buttafuoco | 2006-04-25 15:13:29 | Re: pg_dumpall: does not exist database |