Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting? - Mailing list pgsql-jdbc

From Maciek Sakrejda
Subject Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?
Date
Msg-id CAOtHd0BhXfjO1WGaSHsg-RnQ1Om8Vjds89ifEFagUrZxN7w-tg@mail.gmail.com
Whole thread Raw
In response to Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?  ("David Johnston" <polobo@yahoo.com>)
Responses Re: Bug in AbstracJdbc2Statement.replaceProcessing when using dollar quoting?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
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:

=> create table "$"("$" int);
CREATE TABLE

Not to mention comments.


pgsql-jdbc by date:

Previous
From: the6campbells
Date:
Subject: DatabaseMetadata.getTypeInfo resultset returns more than just Postgres/user defined data types
Next
From: the6campbells
Date:
Subject: ResultSet metadata for a prepared statement missing the applicable table, schema etc properties