| From: | eric(at)gateway(dot)ctlno(dot)com |
|---|---|
| To: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
| Cc: | Amos Hayes <ahayes(at)ingenia(dot)com>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Problem with apostrophe |
| Date: | 1998-06-17 19:44:38 |
| Message-ID: | Pine.LNX.3.96.980617144357.1923B-100000@gateway.ctlno.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Byron Nikolaidis | 1998-06-17 19:54:51 | Re: [GENERAL] Problem with apostrophe |
| Previous Message | The Hermit Hacker | 1998-06-17 19:16:13 | Re: [GENERAL] User Gallery... |