Re: Symbol problem - Mailing list pgsql-admin

From Alfred Perlstein
Subject Re: Symbol problem
Date
Msg-id 20010127014425.L26076@fw.wintelcom.net
Whole thread Raw
In response to Symbol problem  (Bogdan Paduraru <bpaduraru@petar.ro>)
List pgsql-admin
* Bogdan Paduraru <bpaduraru@petar.ro> [010127 01:27] wrote:
> Hello ,
> I made a tool with Java servlets and Postgresql. This tool inputs html text
> into a db. My problem is that everytime I input text that contains  '
> (apostrophe)
> I get an SQL exception.
> This Postgresql can't see by itself what is the difference ?
> I don't want to check every character, this is stupid. I'd rather change
> the RDBMS.

Most every interface into postgresql has a 'quoting' mechanism that
will escape these characters for you.  Check the docs.

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."

pgsql-admin by date:

Previous
From: Bogdan Paduraru
Date:
Subject: Symbol problem
Next
From: Dirk Heinrichs
Date:
Subject: Re: Some thoughts on replication