Search Postgresql Archives

Re: pg_dumpall: does not exist database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxx>
To: jim@xxxxxxxxxxxxxx
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, Stephen Frost <sfrost@xxxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
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@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 -------
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
------- End of Original Message -------



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux