From: | Charles Curley <ccurley(at)trib(dot)com> |
---|---|
To: | "Anthony E (dot) Greene" <agreene(at)pobox(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Pg.pm oddity with apostrophes |
Date: | 2000-08-27 01:28:53 |
Message-ID: | 20000826192853.B28579@trib.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sat, Aug 26, 2000 at 08:33:53PM -0400, Anthony E . Greene wrote:
> On 26 Aug 2000 12:42 Charles Curley wrote:
> >The oddity I have hit is that if I try to inset a name with an apostrophe
> >in it (e.g. O'Neil), pgsql belly-aches and returns an error of 7. The
> >record is not inserted.
>
> Perl will escape the apostrophe and will not pass the backslash on to the
> backend. You will need to use a double backslash:
>
> $sql = "INSERT INTO contacts VALUES ('Mr.','Patrick','O\\'Neil','http://URL')";
Thanks. That also did not work.
--
-- C^2
No windows were crashed in the making of this email.
Looking for fine software and/or web pages?
http://w3.trib.com/~ccurley
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Curley | 2000-08-27 01:45:29 | Re: Pg.pm oddity with apostrophes |
Previous Message | Charles Curley | 2000-08-27 01:25:45 | Re: Pg.pm oddity with apostrophes |