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