Re: [ NOVICE ] Name of database under postgresSQL

> -----Original Message-----
> From: valcauda Stéphane [mailto:valcauda(dot)aderis(at)wanadoo(dot)fr]
> Sent: 01 October 2002 14:39
> To: PostgreSQL Mailing List
> Subject: [ODBC] [ NOVICE ] Name of database under postgresSQL
>
>
> Hi,
>
> I don't understand what is the name of database under
> postgresql. With InitDB we put nothing else the directory.
> THe first connection , I put psql -U <user> template1 which
> seem to create a default database template1. Then, I create 2
> database (CREATE DATABASE ) TEST and TEST2.
>
> But with ODBC or directly in CYGWIN shell , if I try to
> connect to TEST or TEST2 it says that it doesn't recognize these DB.
>
> I don't understand.

Upper, or mixed case names in PostgreSQL must be quoted e.g.

"TEST"

Otherwise it becomes

Test

And doesn't get found. The easy answer is to stick to lower case.

Regards, Dave.