why not just update pg_database set datname='foodmart' where datname like 'foodmart%';
---------- Original Message ----------- From: Ari Kahn <[EMAIL PROTECTED]> To: Tom Lane <[EMAIL PROTECTED]> Cc: Stephen Frost <[EMAIL PROTECTED]>, 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 <[EMAIL PROTECTED]> 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 2: Don't 'kill -9' the postmaster
