On Tue, 2006-04-25 at 17:49, Jim Buttafuoco wrote:
> 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:
> crea
ng
"
you need the double quotes in all cases
-- Original Message ---
From: Ari Kahn <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: Tom Lane <[EMAIL PROTECTED]>, Stephen Frost <[EMAIL PROTECTED]>,
pgsql-general@postgresql.org
Sent: Tue, 25 Apr 2006 11:19:57 -
sql-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 st
resql.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
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
";
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
-
On Apr 25, 2006, at 8:46 AM, Stephen Frost wrote:
* Ari Kahn ([EMAIL PROTECTED]) wrote:
That was a good idea. But this is not the case.
You might try just looking at pg_database directly:
select * from pg_database;
Or (as someone else suggested) pipeing the output into a file which
you can
* Ari Kahn ([EMAIL PROTECTED]) wrote:
> That was a good idea. But this is not the case.
You might try just looking at pg_database directly:
select * from pg_database;
Or (as someone else suggested) pipeing the output into a file which
you can then look at.
As a side-note: I'm a graduate studen
Ari Kahn wrote:
I think the issue is something like this though.
Send the output of your database listing to a pipe through 'cat -evt'
and see if you've got any unusual characters in the names of your databases:
echo '\l' | psql template1 |cat -evt
--
Until later, Geoffrey
Any society tha
Ari Kahn <[EMAIL PROTECTED]> writes:
> On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:
>> If so, I'm wondering if you've got a database with a carriage return
>> embedded in the name, or something like that.
> That was a good idea. But this is not the case.
> postgres=# drop database "\n";
> ERROR:
On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:
Ari Kahn <[EMAIL PROTECTED]> writes:
I was trying to dump all my databases:
su - postgres
/usr/local/bin/pg_dumpall > /Volumes/Space/postgresql_060425.dump
I get:
" does not exist database "foodmartto database "foodmart
", exiting: pg_dump faile
Ari Kahn <[EMAIL PROTECTED]> writes:
> I was trying to dump all my databases:
> su - postgres
> /usr/local/bin/pg_dumpall > /Volumes/Space/postgresql_060425.dump
> I get:
> " does not exist database "foodmartto database "foodmart
> ", exiting: pg_dump failed on database "foodmart
> I guess I had
I was trying to dump all my databases:
su - postgres
/usr/local/bin/pg_dumpall > /Volumes/Space/postgresql_060425.dump
I get:
" does not exist database "foodmartto database "foodmart
", exiting: pg_dump failed on database "foodmart
I guess I had a database called foodmart at one time. However,
13 matches
Mail list logo
