Re: pg_dumpall: does not exist database

just for the record the following also works

from the psql prompt:
jim=# create database "testing
jim"# ";
CREATE DATABASE
jim=# drop database "testing
jim"# "
jim-# ;
DROP DATABASE
jim=#

and from the unix shell:
createdb "testing
"
dropdb "testing
"

you need the double quotes in all cases

---------- Original Message -----------
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
Sent: Tue, 25 Apr 2006 11:19:57 -0400
Subject: Re: [GENERAL] 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 -------
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
------- End of Original Message -------