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@xxxxxxx>
To: Tom Lane <tgl@xxxxxxxxxxxxx>
Cc: Stephen Frost <sfrost@xxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
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@xxxxxxx> 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 -------
