Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?

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