Re: column names and dollar sign

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com>
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:14:56
Message-ID: 19120.1495055696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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 Armand Pirvu (home) 2017-05-17 21:24:39 Re: column names and dollar sign
Previous Message Armand Pirvu (home) 2017-05-17 21:14:16 Re: column names and dollar sign