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

Re: Problem with createdb & case (7.1.3)

From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Problem with createdb & case (7.1.3)
Date: 2001-10-23 04:12:00
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Vijay Deval wrote:
  >from the # prompt, it appears that you are already connected to some
  >   #\c NEUROMR
  >should connect you to the new database.
The # is the root prompt from Unix.  (It's not a good idea to run as root
if you don't have to.)

  >"Chr. Rossmanith" wrote:
  >> Hi,
  >> I'd like to create a database named "NEUROMR". The
  >> command "createdb
  >> NEUROMR" succeeds. But, connecting to this DB fails:
  >> # psql "NEUROMR"
  >> Connection to database 'neuromr' failed.
  >> FATAL 1:  Database "neuromr" does not exist in the

Your problem is that you have created a database with an uppercase name, but
psql is translating it to lowercase.  It probably means you are using an
older version of PostgreSQL, because this doesn't happen for me with 7.1.3.

I don't know how to tell psql from the command line not to do this, so
your best bet is to drop the database (dropdb NEUROMR) and recreate it with
a normal lowercase name.

If you _have_ to connect to NEUROMR, you could try this:

psql -d template1

Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                    
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "I press toward the mark for the prize of the high 
      calling of God in Christ Jesus."         
                                   Philippians 3:14 

pgsql-novice by date

Next:From: Nikola MilutinovicDate: 2001-10-23 06:48:51
Subject: Re: Problems setting up PostgreSQL and Tomcat JDBC connection
Previous:From: hodgesDate: 2001-10-23 00:03:17
Subject: Re: Getting back the primary key after INSERT

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