Re: [GENERAL] column names and dollar sign - Mailing list pgsql-general

From Armand Pirvu (home)
Subject Re: [GENERAL] column names and dollar sign
Date
Msg-id 8968E675-1BE8-4439-A421-837389747509@gmail.com
Whole thread Raw
In response to Re: [GENERAL] column names and dollar sign  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] column names and dollar sign  (Neil Anderson <neil@postgrescompare.com>)
List pgsql-general
Thanks  Tom


Armand

On May 17, 2017, at 4:14 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Armand Pirvu (home)" <armand.pirvu@gmail.com> writes:
>> 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 ?
>
> Postgres thinks it's a valid identifier character, as long as it's
> not the first character.  I don't believe it's standard SQL, but
> we hacked it in a long time ago for compatibility with Oracle or
> somebody like that.
>
>             regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] column names and dollar sign
Next
From: Neil Anderson
Date:
Subject: Re: [GENERAL] column names and dollar sign