Maciek Sakrejda <m.sakrejda@gmail.com> writes:
> On Mon, Sep 24, 2012 at 6:54 AM, David Johnston <polobo@yahoo.com> wrote:
>> Is there any SQL syntax that allows for a dollar-sign outside of a string
>> literal? If not then if we are not in a string and we encounter a
>> dollar-sign we could assume that we are dealing with a PostgreSQL string and
>> immediately return the original input unchanged.
> Identifiers can also contain "$" when quoted:
Identifiers can contain "$" even when not quoted ...
regression=# create table foo$ (bar$ int);
CREATE TABLE
I don't think that's per SQL spec, but PG allows it, mainly because some
other databases do.
regards, tom lane
