Re: [GENERAL] Problem with apostrophe - Mailing list pgsql-general

On Wed, 17 Jun 1998 eric@gateway.ctlno.com wrote:

> Is there any way of having an apostrophe in a data field?
> It is a problem because the apostrophe is the same character as the single
> quote, so the database gets a parser error when a name such as "O'Brian"
> is entered.

Have you tried doubling up?   'O''Brian'

That is what I have to do in Oracle anyway.

--
Amos Hayes                      Systems Architect
ahayes@ingenia.com            Ingenia Group - Software Kinetics Ltd.
http://smurf.ingenia.com/~ahayes        http://www.ingenia.com

"Remember: No one can make you feel inferior without your consent."
   - ELEANOR ROOSEVELT