Re: [HACKERS] Re: [GENERAL] Variable case database names

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Re: [GENERAL] Variable case database names
Дата
Msg-id 200001202204.RAA20758@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Variable case database names  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: [HACKERS] Re: [GENERAL] Variable case database names  (Patrick Welche <prlw1@newn.cam.ac.uk>)
Список pgsql-hackers
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> 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?

We do the same thing with queries, right?  We force identifiers to lower
case unless quoted.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: clyde jones
Дата:
Сообщение: how to for postgres as website backend
Следующее
От: Bruce Momjian
Дата:
Сообщение: New INSTALL text file