Skip site navigation (1) Skip section navigation (2)

Using drop database from psql

From: Lan Barnes <lan(at)falleagle(dot)net>
To: Postgres Newbie <pgsql-novice(at)postgresql(dot)org>
Subject: Using drop database from psql
Date: 2006-01-27 20:07:53
Message-ID: 20060127200753.GA10395@falleagle.net (view raw or flat)
Thread:
Lists: pgsql-novice
When I try to drop a database, whether I have opened it or some other
database, I get told it doesn't exist. The message changes the case of
the database name, but that may be a feature of SQL.

They system is a Fedore Core 3 server running
postgresql-server-7.4.6-1.FC3.1.

Here is the output:

[postgres(at)oz ~]$ psql -d template1
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

template1=# \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 SCM       | postgres | SQL_ASCII
 SCMTST    | lbarnes  | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
(4 rows)

template1=# \q
[postgres(at)oz ~]$ psql -d SCM
Welcome to psql 7.4.6, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

SCM=# drop database SCM;
ERROR:  database "scm" does not exist



Can anyone cast light on this? The database is empty, and I want to
recreate it with a different owner (which may be a task more easily done
with some other method).

-- 
Lan Barnes                    lan(at)falleagle(dot)net
Linux Guy, SCM Specialist     858-354-0616

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-01-27 20:33:25
Subject: Re: Using drop database from psql
Previous:From: Jaime CasanovaDate: 2006-01-27 20:01:15
Subject: Re: Problema con postgresql 8.1.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group