Re: [GENERAL] column names and dollar sign - Mailing list 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