Re: Problem with createdb & case (7.1.3) - Mailing list pgsql-novice

From Chr. Rossmanith
Subject Re: Problem with createdb & case (7.1.3)
Date
Msg-id 3BD55EE3.7124EB3@neuro.ma.uni-heidelberg.de
Whole thread Raw
In response to Problem with createdb & case (7.1.3)  ("Chr. Rossmanith" <cr@neuro.ma.uni-heidelberg.de>)
List pgsql-novice
Hi,

thanks a lot for your responses to my question concerning psql and case.
The hint from Tom Lane was the best. There was an old psql which was
found first in the search path...what a stupid mistake. Now, when using
the correct psql everything works like expected...without any quotes.
(In my original posting I used quotes just to separate commands entered
from my question. I never entered a quoted psql command with options...)

Christina Rossmanith


Vijay Deval wrote:

> Hi
>
> from the # prompt, it appears that you are already connected to some
> database.
>
>    #\c NEUROMR
>
> should connect you to the new database.
>
> Vijay

No, this was just the root users prompt.

>
>
> "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


pgsql-novice by date:

Previous
From: "Fredrik Thunberg"
Date:
Subject: Concatenating strings
Next
From: "Chr. Rossmanith"
Date:
Subject: List of data bases