Re: column names and dollar sign

From: Steve Atkins <steve(at)blighty(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: column names and dollar sign
Date: 2017-05-17 21:10:57
Message-ID: 25DF534A-976B-426D-8C58-DEE24D425921@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Armand Pirvu (home) 2017-05-17 21:14:16 Re: column names and dollar sign
Previous Message Tom Lane 2017-05-17 21:03:20 Re: EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2