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

Re: 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: oddity with apostrophes
Date: 2000-08-27 01:28:53
Message-ID: (view raw or whole 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?

In response to

pgsql-novice by date

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

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