Re: pg_dumpall: does not exist database

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
Subject: Re: pg_dumpall: does not exist database
Date: 2006-04-25 15:08:09
Message-ID: 1667FBA4-2906-4C1A-97CD-B6BC83E661FF@gmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-04-25 15:10:44 Re: postgreslog-semctl(7438339, 4, SETVAL, 0) failed:
Previous Message Tom Lane 2006-04-25 14:51:15 Re: pg_dumpall: does not exist database