Re: Re: Rép. : [GENERAL] double quotes around table and

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Re: Rép. : [GENERAL] double quotes around table and
Дата
Msg-id Pine.LNX.4.33.0211211539240.23898-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Rép. : [GENERAL] double quotes around table and column names  ("Gregory Wood" <gregw@com-stock.com>)
Список pgsql-general
On Thu, 21 Nov 2002, Gregory Wood wrote:

> > The standard is that an identifier (table name, field name, ...) must be
> > double quoted if it contains any non (letter, digits, underscore)
> > character or if it is case sensitive
>
> Is that the SQL standard you are referring to? Because I use underscores
> extensively without double-quotes with no problems.

I think he's saying if you use something OTHER than a letter, digit or
underscore you have to quote it, like

create table crazyname&*$#% ...

would fail, but

create table "crazyname&*$#%" ...

would work.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL compilation with custom table name length
Следующее
От: MT
Дата:
Сообщение: sequenc_name.currval not defined