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

Re: [ NOVICE ] Name of database under postgresSQL

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: valcauda Stéphane <valcauda(dot)aderis(at)wanadoo(dot)fr>,"PostgreSQL Mailing List" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: [ NOVICE ] Name of database under postgresSQL
Date: 2002-10-01 14:02:40
Message-ID: 03AF4E498C591348A42FC93DEA9661B8847A@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc

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

pgsql-odbc by date

Next:From: ilozDate: 2002-10-01 14:10:49
Subject: getting last oid in Visual Basic
Previous:From: valcauda StéphaneDate: 2002-10-01 13:39:17
Subject: [ NOVICE ] Name of database under postgresSQL

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