Drop Database

From: Forest Felling <res08i7v(at)verizon(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Drop Database
Date: 2003-01-19 14:49:00
Message-ID: a05111701ba506afe3a6b@[192.168.1.110]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I can not find an explanation to help me understand why
mydb=# drop database November;
fails, while
[Forest-Fellings-Computer:~] dropdb -i -e November
succeeds.

Will appreciate any help to point me to an understanding of this.

Mac OS 10.2.2; PostgreSQL 7.2.3
Learning SQL with "Practical PostgreSQL" by Worsley & Drake,
"PostgreSQL Essential Reference" by Barry Stinson, "SQL for Smarties"
by Joe Celko and the docs downloaded from http://www.postgresql.org.
Can not find an answer in any of these books.

Complete shell listing follows.

mydb=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
November | fwf | UNICODE
booktown | fwf | UNICODE
homepage | mitch | UNICODE
hospice | fwf | UNICODE
mydb | fwf | UNICODE
template0 | postgres | UNICODE
template1 | postgres | UNICODE
(7 rows)

mydb=# drop database November;
ERROR: DROP DATABASE: database "november" does not exist
mydb=# \q
[Forest-Fellings-Computer:~] fwf% dropdb -i -e November
Database "November" will be permanently deleted.
Are you sure? (y/n) y
DROP DATABASE "November"
DROP DATABASE
[Forest-Fellings-Computer:~] fwf%

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-01-19 16:17:32 Re: Drop Database
Previous Message Forest W Felling 2003-01-19 14:44:48 Drop Database