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

Re: Pg.pm oddity with apostrophes

From: Webb Sprague <wsprague100(at)yahoo(dot)com>
To: Charles Curley <ccurley(at)trib(dot)com>, pgsql-novice(at)postgreSQL(dot)org
Subject: Re: Pg.pm oddity with apostrophes
Date: 2000-08-26 17:33:19
Message-ID: 20000826173319.4441.qmail@web805.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
I haven't messed to much with it, but I think that if
you use two apostrophes like '', that may work to
escape it.

--- Charles Curley <ccurley(at)trib(dot)com> wrote:
> I am using pg.pm with perl to interface between a
> web server,
> Apache, and postgres. Pg.pm is as follows:
> 
>
#-------------------------------------------------------
> #
> # $Id: Pg.pm,v 1.8 1998/09/27 19:12:22 mergl Exp $
> #
> # Copyright (c) 1997, 1998  Edmund Mergl
> #
>
#-------------------------------------------------------
> 
> 
> [PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by
> gcc pgcc-2.91.66]
> 
> 
> 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. If I remove the apostrophe,
> the otherwise identical
> record goes in just fine. I am escaping the
> apostrophe correctly, as far
> as I know. The insert query is as follows:
> 
> Insert into contacts VALUES ( 'Mr.', 'Patrick',
> 'O\'Neil', blah, blah... 'http://URL' ); "
> 
> I can insert the name from psql with no problems,
> which makes me think it
> is a Pg.pm problem.
> 
> -- 
> 
> 		-- 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

> ATTACHMENT part 2 application/pgp-signature 



__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/

Responses

pgsql-novice by date

Next:From: Jesus AneirosDate: 2000-08-26 17:40:21
Subject: Re: Pg.pm oddity with apostrophes
Previous:From: Charles CurleyDate: 2000-08-26 16:42:11
Subject: Pg.pm oddity with apostrophes

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