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

From Steve Atkins
Subject Re: [GENERAL] column names and dollar sign
Date
Msg-id 25DF534A-976B-426D-8C58-DEE24D425921@blighty.com
Whole thread Raw
In response to [GENERAL] column names and dollar sign  ("Armand Pirvu (home)" <armand.pirvu@gmail.com>)
Responses Re: [GENERAL] column names and dollar sign  ("Armand Pirvu (home)" <armand.pirvu@gmail.com>)
List pgsql-general
> On May 17, 2017, at 2:02 PM, Armand Pirvu (home) <armand.pirvu@gmail.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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2
Next
From: "Armand Pirvu (home)"
Date:
Subject: Re: [GENERAL] column names and dollar sign