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

From eric@gateway.ctlno.com
Subject Re: [GENERAL] Problem with apostrophe
Date
Msg-id Pine.LNX.3.96.980617144357.1923B-100000@gateway.ctlno.com
Whole thread Raw
In response to Re: [GENERAL] Problem with apostrophe  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List pgsql-general
the escape character brings up the help menu, thinking that \' is not a
valid option.

On Wed, 17 Jun 1998, Brett W. McCoy wrote:

> 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
>


pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [GENERAL] Problem with apostrophe
Next
From: Byron Nikolaidis
Date:
Subject: Re: [GENERAL] Problem with apostrophe