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

Re: Using drop database from psql

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Lan Barnes <lan(at)falleagle(dot)net>, Postgres Newbie <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Using drop database from psql
Date: 2006-01-28 01:40:03
Message-ID: f7f6b4c70601271740j7be081a2hf83b9347d276241b@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Lan,

Beside Tom's comments, you won't be allowed to drop the database while you
are working on it.
(no drop database will succceed if users are still working).  So, connect to
template1 and fire the SQL with the quotes (dixit Tom Lane) or just use the
dropdb command line tool


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

Regards,
Guido Barosio

On 1/27/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Lan Barnes <lan(at)falleagle(dot)net> writes:
> > SCM=# drop database SCM;
> > ERROR:  database "scm" does not exist
>
> > Can anyone cast light on this?
>
> Case-folding.  Within SQL you'd need to refer to that database as
> "SCM" (with the double quotes).  We don't do case-folding for names
> used on the shell command line, but within SQL this is per spec.  See
> the last paragraphs in this section:
>
> http://www.postgresql.org/docs/7.4/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
>
>                         regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>



--
/"\   ASCII Ribbon Campaign  .
\ / - NO HTML/RTF in e-mail  .
X  - NO Word docs in e-mail .
/ \ -----------------------------------------------------------------

In response to

pgsql-novice by date

Next:From: richardDate: 2006-01-28 09:13:25
Subject: problem with pg_dump - attrdef record(s) missing
Previous:From: Luzmar Caicedo UsecheDate: 2006-01-28 00:08:37
Subject: Problem with pg_dump

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