"Chr. Rossmanith" <cr@neuro.ma.uni-heidelberg.de> writes:
> # psql "NEUROMR"
> Connection to database 'neuromr' failed.
Hmm. psql seems to be downcasing your database name for you.
But it hasn't done that in a long time ... not since 7.0, at least,
which is the oldest version I have handy to check. Are you
sure your psql program is up to date? (Try psql -V to see the
version of psql itself. If it doesn't give you one, it's
definitely too old.)
I think that in older psql versions it would work to say
psql '"NEUROMR"'
(you need the extra quoting level to keep the shell from stripping
off the double quotes). But we got rid of the auto-downcasing
feature for database names entered on the command line, because
this was too much of a pain in the neck.
regards, tom lane