Re: [GENERAL] Variable case database names
От | Peter Eisentraut |
---|---|
Тема | Re: [GENERAL] Variable case database names |
Дата | |
Msg-id | Pine.LNX.4.21.0001202242260.349-100000@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: [HACKERS] Re: [GENERAL] Variable case database names
Re: [HACKERS] Re: [GENERAL] Variable case database names |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: