Re: [GENERAL] column names and dollar sign

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема Re: [GENERAL] column names and dollar sign
Дата
Msg-id 25DF534A-976B-426D-8C58-DEE24D425921@blighty.com
обсуждение исходный текст
Ответ на [GENERAL] column names and dollar sign  ("Armand Pirvu (home)" <armand.pirvu@gmail.com>)
Ответы Re: [GENERAL] column names and dollar sign  ("Armand Pirvu (home)" <armand.pirvu@gmail.com>)
Список pgsql-general
> 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



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2
Следующее
От: "Armand Pirvu (home)"
Дата:
Сообщение: Re: [GENERAL] column names and dollar sign