From: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
---|---|
To: | Amos Hayes <ahayes(at)ingenia(dot)com> |
Cc: | eric(at)gateway(dot)ctlno(dot)com, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Problem with apostrophe |
Date: | 1998-06-17 19:57:47 |
Message-ID: | Pine.BSI.3.91.980617155655.29739E-100000@access1.lan2wan.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-06-17 22:45:52 | Re: [GENERAL] User Gallery... |
Previous Message | Byron Nikolaidis | 1998-06-17 19:54:51 | Re: [GENERAL] Problem with apostrophe |