There is some code in libpq which converts all database names to
lower-case, unless it's double quoted. That seems a little ill-conceived
to me, since you'd actually have to pass it something like
PGconnectdb("dbname=\"Newnham\"");
If anything, this would make it inconvenient it psql, because you'd have
to write
\c '"Newnham"'
since
\c "Newnham"
is interpreted differently.
Does anyone have an explanation for this? Why not leave the name as is?
On 2000-01-20, Patrick Welche mentioned:
> List of databases
> Database | Owner
> ------------+----------
> Newnham | prlw1
>
> % psql Newnham
> psql: connection to database "newnham" failed - FATAL 1: Database "newnham" does not exist in the system catalog.
>
> template1=> \c 'Newnham'
> FATAL 1: Database "newnham" does not exist in the system catalog.
> Previous connection kept
>
>
> How can I connect to a database with a variable case name?
>
> Cheers,
>
> Patrick
>
> ************
>
>
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden