Re: [GENERAL] column names and dollar sign

Поиск
Список
Период
Сортировка
От Armand Pirvu (home)
Тема Re: [GENERAL] column names and dollar sign
Дата
Msg-id CFFE702B-B76D-420F-BF11-E3AFCF38525C@gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] column names and dollar sign  (Steve Atkins <steve@blighty.com>)
Список pgsql-general
Thank you Steve

— Armand

On May 17, 2017, at 4:10 PM, Steve Atkins <steve@blighty.com> wrote:

>
>> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) <armand.pirvu@gmail.com> wrote:
>>
>> Hi
>>
>> Ran into the following statement
>>
>> CREATE TABLE test(
>>     Date$ date,
>>     Month_Number$ int,
>>     Month$ varchar(10),
>>     Year$ int
>> );
>>
>>
>> While it does execute, I wonder if the $ has any special meaning ?
>>
>> Can anyone shed some light please ?
>
> No special meaning to postgresql - in postgresql a dollar sign is a valid character in an identifier.
>
> It might have some special meaning to the app that was using it, perhaps.
>
> Cheers,
>  Steve
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



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

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: [GENERAL] column names and dollar sign
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] column names and dollar sign