Re: Using drop database from psql

Lan Barnes <lan@falleagle.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