Re: escape single quote in INSERT command

If you're using DBD::Pg, just use ? placeholders without any quotes and let
it do the escaping for you:

$sth = $dbh->prepare("insert into customer (name) values (?)");
$sth->execute($name);

Makes the code a little more portable too. Hope this helps,

Wes

dave_h4(at)yahoo(dot)com (Hunter)@postgresql.org on 11/22/2002 08:00:31 AM

Sent by: pgsql-general-owner(at)postgresql(dot)org

To: pgsql-general(at)postgresql(dot)org
cc:
Subject: [GENERAL] escape single quote in INSERT command

Hi Group -

I have a perl application for a registration form. I'd like to put
escape characters in my insert command to accommodate for '
(i.e. O'Brien, O'Malley, etc). I've tired double quotes, single
quotes, back tick, forward ticks, curly bracket, round brackets - no
success.

Thanks, dave

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org