Re: column names and dollar sign

Thank you Steve

— Armand

On May 17, 2017, at 4:10 PM, Steve Atkins <steve(at)blighty(dot)com> wrote:

>
>> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) <armand(dot)pirvu(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general