Re: pg_dumpall: does not exist database

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 -------