Re: column names and dollar sign

From: "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: column names and dollar sign
Date: 2017-05-17 21:24:39
Message-ID: 8968E675-1BE8-4439-A421-837389747509@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Tom

Armand

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

> "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Anderson 2017-05-17 23:32:29 Re: column names and dollar sign
Previous Message Tom Lane 2017-05-17 21:14:56 Re: column names and dollar sign