From: | "Jim Buttafuoco" <jim(at)contactbda(dot)com> |
---|---|
To: | Ari Kahn <akahn1(at)gmu(dot)edu>, 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 |
Subject: | Re: pg_dumpall: does not exist database |
Date: | 2006-04-25 15:13:29 |
Message-ID: | 20060425151302.M29577@contactbda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 -------
From | Date | Subject | |
---|---|---|---|
Next Message | Ari Kahn | 2006-04-25 15:19:57 | Re: pg_dumpall: does not exist database |
Previous Message | Tom Lane | 2006-04-25 15:10:44 | Re: postgreslog-semctl(7438339, 4, SETVAL, 0) failed: |