Re: String escaping? - Mailing list pgsql-jdbc

From Mark Lewis
Subject Re: String escaping?
Date
Msg-id 1166032066.27428.92.camel@archimedes
Whole thread Raw
In response to Re: String escaping?  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: String escaping?
List pgsql-jdbc
The only exception to this rule is backslashes and (when using LIKE) the
'%' and '_' characters.  Although if you're running 8.2 and turn the
standard_conforming_strings setting ON then you don't need to worry
about backslashes.

-- Mark Lewis

On Wed, 2006-12-13 at 17:21 +0000, Heikki Linnakangas wrote:
> David Nedrow wrote:
> > Are there any build-in JDK or JDBC (Sun or Postgresql driver) functions
> > for escaping strings before inserting/updating in the DB?
> >
> > Eg., I'm using the following PreparedStatement...
>
> You don't generally need to escape your strings if you're using
> PreparedStatements.
>

pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: String escaping?
Next
From: Ken Johanson
Date:
Subject: PG 8.2's JDBC, and Statement.executeUpdate(String, String[]) causing AbstractMethodError