Re: case sensitivity for tables, columns, and constraint names

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: case sensitivity for tables, columns, and constraint names
Дата
Msg-id 20071211173037.GL27409@crankycanuck.ca
обсуждение исходный текст
Ответ на case sensitivity for tables, columns, and constraint names  ("Ertel, Steve" <Steve.Ertel@infimatic.com>)
Список pgsql-sql
On Tue, Dec 11, 2007 at 11:05:25AM -0600, Ertel, Steve wrote:

> is wrapped in quotes.  Is there a setting to allow upper case and mixed
> case names for database tables, fields, etc, without having to wrap each
> in quotes?

No, sorry.  The always-one-case rule for unquoted identifiers is ANSI
conformant.  As it happens, the ANSI rule also makes everything ALLCAPS, but
PostgreSQL doesn't go that way (for historical reasons).

A


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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: case sensitivity for tables, columns, and constraint names
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: case sensitivity for tables, columns, and constraint names