Postgres Pro
Downloads
Home   >   mailing lists

Thread: Characters which requires escaping

Characters which requires escaping

From
"Antony Paul"
Date:
Hi all,
    What are the characters which requires an escape sequence when used in
the query. I am writing an application using JDBC.

rgds
Antony Paul

Re: Characters which requires escaping

From
Peter Eisentraut
Date:
Antony Paul wrote:
>     What are the characters which requires an escape sequence when
> used in the query. I am writing an application using JDBC.

That depends on which part of the query you are talking about.
Different syntactic constructs have different escaping rules.

Re: Characters which requires escaping

From
Paul Thomas
Date:
On 10/07/2004 14:44 Antony Paul wrote:
> Hi all,
>     What are the characters which requires an escape sequence when used
> in
> the query. I am writing an application using JDBC.


If youn use PreparedStatements, the driver will do the escaping for you.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+