Skip site navigation (1) Skip section navigation (2)

Re: Pg.pm oddity with apostrophes

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: Charles CurleyDate: 2000-08-27 01:45:29
Subject: Re: Pg.pm oddity with apostrophes
Previous:From: Charles CurleyDate: 2000-08-27 01:25:45
Subject: Re: Pg.pm oddity with apostrophes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group