Horton

Re: [GENERAL] Problem with apostrophe

Brett W. McCoy <bmccoy@lan2wan.com>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@lan2wan.com>
To: Amos Hayes <ahayes@ingenia.com>
Cc: eric@gateway.ctlno.com, pgsql-general@postgreSQL.org
Date: 1998-06-17T19:57:47Z
Lists: pgsql-general 
On Wed, 17 Jun 1998, Amos Hayes 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.

Isn't there an escape character, like the slash?

Brett W. McCoy           
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
"The Number of UNIX installations has grown to 10, with more expected."
   -- The UNIX Programmer's Manual, 2nd Edition, June, 1972