Re: Using drop database from psql

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 .
/ \ -----------------------------------------------------------------